Topics
Started by
Posts
Last post
2 replies
How do i drop and Recreate indexes during ETL?
3 replies
if two tabel has two same schema,but not primary - foreign relation,i want to identify matching rec…
6 replies
I have a table mytable that has columns like this: A-ID, A-Name, B-ID, B-Name, C-ID, C-Name, D-ID,…
3 replies
Hello fellow SQL'ers, I have been assigned a task to create a new ERD for the database that I have…
1 replies
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
Viewing 15 topics - 6,616 through 6,630 (of 10,635 total)
You must be logged in to create new topics.