Friday, May 17, 2013

[SQL Server] How to delete a record with different column values?

[SQL Server] How to delete a record with different column values?

How to delete a record with different column values?

Posted: 17 May 2013 03:06 AM PDT

I have a table where the unique identifier is studentId.Now this table contains decision columnIf decision has been made, then decision='yes'/'No'If decision hasn't been made decision='none'Now the tables gets appended when the decision has been made, so for a student, we get 2 rows one, with decision='none' and other with decision='yes'/'No'I just want to delete the row for decision ='none' when there is a yes/no decision. For each row there is a unique DecId.So for 2 rows with same emplid, we have 2 different DecId.How do I do that?Thanks,Blyzzard

Sql server relationship using between 2 values

Posted: 16 May 2013 11:29 PM PDT

I have a database that contains 2 tables (sql server 2008):[b]LenderCommission[/b]ID intCommission decimal[b]CommissionTier[/b]ID intMinCommission decimalMaxCommission decimalI want to create a relationship between the 2 tables. The obvious way would be to add CommissionTierId to the LenderCommission table, however this is then fixed. If the commission structure of a tier changed all LenderCommissions would need to be revaluated.I'm no expert but I'm guessing that it's not possible to create a relationship where Commission is between MinCommission and MaxCommission. However, is there any way in which this relationship can be made more fluid?

Month and Year text field columns to Date field in SQL 2005

Posted: 17 May 2013 12:08 AM PDT

In SQL 2005, I have 2 text field columns. One is month and the other is year. I would like to convert these 2 columns into a date field with this format: 8/1/2009 Thank you so much in advance :-)Jacky

Adding LinkedServer in Uppercase and Lowercase

Posted: 16 May 2013 10:45 PM PDT

I am trying to find out how could I add two linkedserver with the same name, one in uppercase and the one in lowercase using sp_addlinkedserver or some other kind of script.Your help is very much appreciated.Regards

Entry Level DBA position - SQL Server experience needed

Posted: 15 Mar 2013 12:14 AM PDT

Hello,I have a job opportunity for an Entry Level DBA located in Malvern, PA and they are looking for someone with an IT-related degree as well as some SQL Server and DBA experience. If you are interested please contact me at dana.murk@insightglobal.net.Thank you!-Dana
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog