Topics
Started by
Posts
Last post
Hi, I have a zone table as ZoneIDZoneDesc 1North Zone 2East Zone 3West Zone 4South Zone what …
4 replies
ello, I have three different sample T-sqls that almost produce the same result except the sql t…
8 replies
I have a query for a report in SSRS that is bringing back various columns for the report I am worki…
1 replies
Hi everyone. I need some help here. Until now I thought I understood how the procedure cache work…
10 replies
Yes, normally, I would import large recordsets with SSIS. For now, lets just assume that I have goo…
5 replies
Hi, I need some help with pivot table and calculations. CREATE TABLE #Derived ( ID INT IDENTITY(1,1…
3 replies
Hey, is there a way to bring a select and a a while loop for a row together? What I like to do is a…
8 replies
CREATE TABLE #NEWTABLE (ID VARCHAR(20),NAME VARCHAR(30)) INSERT INTO #NEWTABLE VALUES('100','samso…
2 replies
I have below formatted text file each record for a user is separated with space, userid is unique v…
19 replies
I have a large database table (on the server it is larger with about 4 million rows) that has the f…
3 replies
I have a temp table inside a stored procedure. When I run @@rowcount after executing SP, it always …
4 replies
Hi all We've got a lot of stored procedures in source control and, currently, we use an "IF EXISTS"…
9 replies
I have an insert statement like this - Insert into TableA (Col1,Col2,Col3) SELECT variable1,functio…
13 replies
INSERT INTO [NewTable] SELECT * FROM OPENROWSET ( 'MSDASQL', 'Driver={Microsoft Text Driver (*.txt;…
5 replies
Hi, I need to convert varchar datatype "14-Apr" into datetime datatype "2014-04-01 00:00:00.000" Th…
11 replies
Viewing 15 topics - 2,371 through 2,385 (of 4,984 total)
You must be logged in to create new topics.