Topics
Started by
Posts
Last post
Hi, RE:SQL Server 2005 Here's a script generator to enable all of the sql logins except sa: declar…
10 replies
i create a store procedure in which i use multiple cursor. Problem when @@fetch_status =0 and for w…
2 replies
Hi, We have a mixture of 32-bit and 64-bit database servers, all running SS2K5 SP2. In various s…
1 replies
Hi SQL experts: I am using SQL2008 and wondering how to loop through tables with dynamic names? I h…
5 replies
Adding data to a text field ??? Or to data how should I declare that column, as a text , or varchar…
1 replies
Hey GUys, I do not need the cursor to break after failures and want to iterate through all the reco…
3 replies
I am having problems trying to flatten the XML below. I cannot seem to figure how to get the LON s…
12 replies
Hi, We are looking to run all of our SSRS subscription jobs via TSQL and SQL doesnt seem to like to…
1 replies
I need help to build the insert statement for insert the following tag into my table: Insert INTO …
4 replies
I won't put the entire SP here because its not relevant but I can't get this to work at all. I can'…
1 replies
Hi Everyone, I need some help with the logic to use a tally table to accomplish the following. I th…
1 replies
Msg 8152, Level 16, State 14, Line 145 String or binary data would be truncated. The statement has …
2 replies
Hi: I've a stored procdure which inserting data from one table to another table in my db. I use cur…
4 replies
CREATE PROCEDURE [dbo].[p_getCallStats] @Col1 int = null, @col2 datetime = NULL, @col3 int = NUL…
3 replies
Hi , I have a table which has parent child relation ship. I need to build a stored procedure which…
3 replies
Viewing 15 topics - 5,701 through 5,715 (of 12,231 total)
You must be logged in to create new topics.