343 reputation
115
bio website
location
age
visits member for 2 years, 4 months
seen 18 hours ago

2d
asked Deploying SSRS reports on an “Air Gapped” report server without SSDT?
Mar
20
comment Is it possible to execute queries in random order?
@Muis So, let me get this straight, you have queries coming from different machines, with out of sync clocks , and you need to figure out a way to get them in the correct order somehow?
Mar
19
answered Connecting to a SQL Server database kept on an online server by c# windows forms
Mar
19
comment placing conditions in a join query join on vs where
Try them out and check the query plan. AFAIK SQL Server treats both as the same
Mar
19
answered Cannot open database “RidaDatabase” requested by the login. The login failed. Login failed for user 'PLESK01\IWAM_plesk(default)'
Mar
19
answered Is it possible to execute queries in random order?
Mar
19
answered Should my application utilize database credentials for user login?
Feb
26
awarded  Critic
Feb
25
comment Check if query will cause duplicate row
@MartinSmith Interesting.. didnt realize you could do that :)
Feb
25
revised Check if query will cause duplicate row
deleted 21 characters in body
Feb
25
comment Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Yup.. looks like you need to do an UPDATE and not an INSERT here... You basically want to populate the SupplierContactName in the PurchaseInfo table where the SupplierName is present in the PurchaseInfo table right? Take a look at the statement in my answer
Feb
25
comment Check if query will cause duplicate row
Try example 2...
Feb
25
revised Check if query will cause duplicate row
added 224 characters in body
Feb
25
comment Check if query will cause duplicate row
So if you have 4 rows 'David',1 ' David',2 'David ',3 and ' David ',4 , you want to delete all 4?
Feb
25
revised Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Formatting fix
Feb
25
comment Check if query will cause duplicate row
@Dmandy, whats your final objective? The above query will identify which all rows will cause a duplicate, what do you wish to accomplish next?
Feb
25
answered Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Feb
25
comment Inserting values into a column when Table1 column A value matches Table 2 Column B Value
You seem to want to do an update, not insert
Feb
25
comment Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Can you post the schema of PurchaseInfo as well?
Feb
25
suggested approved edit on Inserting values into a column when Table1 column A value matches Table 2 Column B Value