Topics
Started by
Posts
Last post
Hi All How would I setup a script to copy files from a shared location on one server, to a shared l…
7 replies
Hello All, when I executed this query SELECT COUNT(*) FROM temp_view where CONVERT(datetime, DAT…
1 replies
Hi All, I have a join table that in which I want to maintain historical relationships. Pardon my la…
4 replies
I have a query from msdb..backupset that displays Database Name and Compression Ratio, but it displ…
3 replies
Hello all, CREATE TABLE #pyft001 ( py_fl BIT , fy INT , p_nm VARCH…
8 replies
Hi, I was wondering if anyone has a solution for me. I am writing SEVERAL sprocs to update differe…
10 replies
it is quite slow as you will see from the execution plan it should be returning just over 1.5 mill…
8 replies
Hey guys, how can I declare a variable of datatype int that only can be assigned the values 1,2,3,4…
8 replies
There is a way to send an email file that is stored in a column 'binary' through 'msdb.dbo.sp_send_…
1 replies
I haad written a query using dense_rank() it returns the following table HotelID RoomID Age…
10 replies
I have a table that has many columns. I want to return all the columns of the rows with the greate…
6 replies
Hi, What is the equivalent of ORACLE “MONTH_between “ in SQL ? I want in months…. I tried the Dat…
3 replies
Hi All I'm trying to get out of using cursors to solve my T-SQL problems Without using a cursor, I …
13 replies
Have created Scalar User Defined Function and when i try to execute the function it fails.What coul…
4 replies
Can you please help me to get the median using the cursor How I wrote the following code using the …
1 replies
Viewing 15 topics - 5,551 through 5,565 (of 10,647 total)
You must be logged in to create new topics.