Topics
Started by
Posts
Last post
Hi Everyone, How to find out who has looged on or connected to my sql server…
3 replies
Can this be done? I can get a query to return a comma delimited string of results using Coalesce bu…
5 replies
I don't fully understand how the splitter and the tally table works well enough to use it for alter…
18 replies
Hi all, I'm new to SQL, any instructions or sample code to create the Store Proc below would be gr…
10 replies
I'm going to delete about 8 million recs from a table who has 27 milllion records. I had planned on…
9 replies
Hi, I have the below data: HOSTNAMESERVERCHANNELDATE COUNTER_NM COUNTER_VAL T…
15 replies
Wanted to drop all the users and roles from the database which is recently restored from other envi…
9 replies
Hello, I have a question on a purge process. I have one main “Stage” table and other 10 transitions…
1 replies
How do you omit the null values returned inthis query? SELECT CASE WHEN MONTH(DueDate)=5 THEN DueDa…
11 replies
When I alter a column length for a table, do I need to refresh its trigger? I asked this is because…
2 replies
How do you get the date for every Friday in a particular quarter?
3 replies
Hi, Please look at the below query and suggest if there is a cleaner way to achieve this. This is t…
3 replies
Hi friends I have start time and end time , I need to get is the time difference between 2datetime…
3 replies
Hi All, I have a bit of a puzzle and my brain decided it didn't want to come to work today. Please …
40 replies
Can this be done? I can get a query to return a comma delimited string of results using Coalesce bu…
2 replies
Viewing 15 topics - 5,806 through 5,820 (of 10,647 total)
You must be logged in to create new topics.