Topics
Started by
Posts
Last post
Hi Below is query , I allways have a value for variable1 but for variable2 and variable3 if their …
6 replies
Hi, Believe me this is a hugely scaled-down version of want I need... I have a SQL table (dbo.LSR_P…
6 replies
Hi, How to get the transaction log details like who enters in to the server, in which login, What t…
1 replies
Here is a head scratcher... Back Story: Operations has come and informed me that they now allow emp…
11 replies
Hi, Is there any way to give the Descriptions for the columns while creating the SQL table? Thanks …
0 replies
Hi If you run: backup database xxx to disk = 'c:\xxx.bak' It returns: Msg 911, Level 16, State 11, …
1 replies
Hello, I'm writing a stored procedure that once a day pulls data from master database A to database…
2 replies
I am currently trying to create a stored procedure as part of an ETL process that I am working on. …
9 replies
I already had a post on this. I was trying to get results per database. I thought sp_msforeachdb wo…
1 replies
Hi, I need to cleanse some address data that has empty strings in the middle of the some columns. I…
8 replies
Hello, I have 2 tables that I need to compare and find the differences. Table1: CREATE TABLE STANDA…
3 replies
Hi, Do we have any algorithm or procedure or a user defined function to which i can pass the tables…
3 replies
We have a "zero" down time policy, yea i know, it's crazy, which I am attempting to conform to. Ess…
6 replies
CREATE PROCEDURE Delete_Template ( @IDBIGINT, @StatusBIT OUTPUT ) BEGIN BEGIN TRY BEGIN TRAN…
2 replies
HI, i have one table from that table i want top3 rows from each userid , here userid is not unique,…
5 replies
Viewing 15 topics - 3,916 through 3,930 (of 12,230 total)
You must be logged in to create new topics.