Topics
Started by
Posts
Last post
I tried to excute a stored procedure, but it gives the sysntax error on the last line EXECUTE @rc…
5 replies
Hi: I inherited a process that compares about 90 fields from an import staging table to the corresp…
10 replies
Does somebody have an update select script they can post for me. I knwo I've done them before but I…
18 replies
There is a table which has: PersonName PersonNameType transaction# PersonNameType either = buyer or…
5 replies
I have a table with below structure Create table TestClient (ID int, InternalCode nvarchar(100)) I…
8 replies
Hi, I have two temp tables #TableA ( PKID INT ,KEY char(18), TaxA decimal(6,2) ,Discount decimal…
7 replies
I have worked with SQL for a few years now, but have never seen the + - symbols used like they are …
5 replies
I have 2 requests. The first one do an "index seek", and the 2nd do an "Cluster Index Scan" ... Do…
18 replies
Hello All, (btw still new to t-sql) I am trying to return values for each row in a grouped table. (…
2 replies
is anyone able to convert this query using a WHILE LOOP? I do not want recursive CTE DECLARE @tab1 …
6 replies
Hi NOTE: Sample and Expected results scripts at end of text Amendment: PLEASE USE THE EXPECTED RE…
9 replies
Hello, I have to columns in a table of which both are a varchar datatype. I need to concatenate th…
4 replies
Hi, For my own sanity, I need the following explained to me. It was an issue we picked up in a PROD…
1 replies
I'm getting this error, and I know how to fix it, but I don't understand why I'm getting it. I crea…
1 replies
I need to get a sum of the size of a certain set of tables in megabytes. I know I can use sp_space…
1 replies
Viewing 15 topics - 6,631 through 6,645 (of 10,647 total)
You must be logged in to create new topics.