Topics
Started by
Posts
Last post
Hi, can anyone help me. i need to Export specific columns to excel and keep some existing fomulas i…
1 replies
I have a datetime column from which i want to remove time part & keep the output as date format…
17 replies
Hello, I have the need to create an energy consumption report. The store procedure below retrieves…
4 replies
I want to exec(@sql) but i am strruggling when the SP has outputs. How do I do this? Many thanks
2 replies
studentID subjectIDsubjectMark 1192 1288 1388 1483 1583 1674 2178 2289 2365 24…
22 replies
I am trying to get rid of minutes, seconds and nanoseconds by zeroing them so I can group dates on …
6 replies
A strange behavior of the Isnull() function. I found a behavior with the IsNull() function that I c…
2 replies
Hi, I need to set a flag if the StartDate is Continous in the Temp Table.Suppose the StartDate is '…
9 replies
Hi to all expert, i need help to convert the row into a column here are the example: the original t…
3 replies
Hi, more than one sql statements are possible in stored procedure?
2 replies
Hi All I have a case statement which looks are 3 different columns to evaluate the expressions, the…
2 replies
Begineer wants to know if simple way to transform 'hardcoded' SQL with Case statement to some sort …
3 replies
Everything works but I need output in a Matrix like format. Below is a sample structure create Tabl…
1 replies
I have a really simple SELECT statement & I want the results to a file so I can schedule it to…
2 replies
Hi guys.. I want to convert from datetime to time part only. Like this sample : 6/4/2009 3:50:06 PM…
9 replies
Viewing 15 topics - 1,621 through 1,635 (of 17,082 total)
You must be logged in to create new topics.