Topics
Started by
Posts
Last post
Looking for best way to, with T-SQL only, remotely execute DML when remote server is not known at d…
1 replies
My left outer join below works in a sql query window just as I would expect however not in my store…
5 replies
Hi, Is there an easier way to select number of hours worked between 23:00 on Fridays and 07:00 Mond…
10 replies
Hi, I need to update a field (Order_Rank) to display 'rank values' based on other columns within th…
3 replies
Hi all. I have a table that contains data about customer,seller, and visits. The problem I have is …
2 replies
The below query takes some wheer 6 to 9 seconds each time.. declare @GUID char(36) set @GUID ='ec…
12 replies
Hi. I wrote a query to select the Top25 records from my dataset. I now want to write another query …
8 replies
We are running SQL Server 2005 SP3 on Windows Server 2003. I have some TSQL set up to run within a …
1 replies
HI everyone, I have a issue If the input string = '1001,2001,1002,2002,1003,2003' I need the resul…
3 replies
Hi. I need to create a (shared) folder and a txt file in T-SQL 2005 without using xp_cmdshell for s…
6 replies
This statement does not work correctly but I am not sure why. If I split it up and run each individ…
2 replies
Does anyone have a cool idea how to for a process in sql other than using a job or xp_cmdshell? e.g…
5 replies
Here is my sample cursor code, DECLARE test CURSOR FOR SELECT …. FROM tablename where …. O…
1 replies
Hi I have data values like '00058', this means 58 minutes, and trying to sum of all the row values …
4 replies
Ok, here's the situation...I have a project to create a search procedure. This search procedure nee…
1 replies
Viewing 15 topics - 2,701 through 2,715 (of 12,234 total)
You must be logged in to create new topics.