Topics
Started by
Posts
Last post
Hi Friends, I want to change Set clause of Update Statement dynamically based on some condition. Ba…
7 replies
UPDATE Report SET MSYear= casewhen MSDate > '2011/06/30' and MSDate < '2012/07/01' THEN …
4 replies
DELETE FROMtemp WHEREMSDate < '2014-07-15' Actually our business year starts from july 1st so …
1 replies
UPDATE Tablename SET Year= casewhen MSDate > '2011/06/30' and MSDate < '2012/07/01' THEN …
7 replies
Hi Team, using below query to raplace the string values (REPLACE abc with T1223), how to use the qu…
2 replies
Hi I have a more than 50 departments in my table and trying to get top 10, something I need to sh…
3 replies
The below TSQL query takes about 19 minutes to run SELECT count(distinct SessionID) ) FROM SessionT…
1 replies
Hello, I'm having some issues with a complex query in SQL. I have a date table(A) for every day of …
2 replies
I have two tables: tblServer tblInstance tblServer represents a server, tblInstance represents any …
3 replies
I am trying to make my code more efficient because I am going to have to write about 120 different …
3 replies
I have a table with a text field and a grouping number. 1, A 1, B 1, C 1, D 1, E 2, A 2, C 2, D 2, …
15 replies
Hello, I am having trouble with joining 3 tables. 1 table is the primary call it jobs, second is ma…
2 replies
DELETE FROM Report_temp2 WHERE MSSalesID in ( Select Report_temp.MSSalesID FROM Report_temp) …
4 replies
SQL 2008 I have a table that has company id, attachment file name, folderexists columns. First wha…
11 replies
I have a table Alert_Types with these fields : alert_id, alert_source, body, Now whenever a new ale…
13 replies
Viewing 15 topics - 1,186 through 1,200 (of 10,647 total)
You must be logged in to create new topics.