Topics
Started by
Posts
Last post
Hello Everyone I am having a real time with this one. --===== If the test table already exists, dr…
13 replies
I have a VLDB VLtable (>300GB table) that I need to move from a development environment to a pro…
2 replies
Hi, has anyone got an example of a Dynamic SQL and what is it and why it would benefit using this? …
18 replies
hi, In my work environment i have faced problem with getting data from two different sql servers li…
3 replies
Hello, I have a problem with selecting rows which I want to update. Select sets a read lock on the …
6 replies
Hi there, Apologies for the elusive subject title. I'm trying to filter only rows on one field onl…
5 replies
I have a question for which I want to know how it works internally Lets consider below query Select…
8 replies
I'm doing a DB review and have always been taught to write updates with a Join like using this synt…
25 replies
I use a merge statement to do incremental load to the table. I use it in a stored procedure that is…
10 replies
hi ALL, ;WITH CTE_BALANCE(SLNO,RECEIVED,PAID,BALANCE) AS ( SELECT slno,received,paid,CAST(I…
8 replies
Hi. I have a table with figures below. 003223 003225 003227 003227A 003236 003236A 003241 003273 00…
8 replies
Anyone see a problem with this query? SELECT tblTransactions.PO_Number, tblTransactions.PO_Date, tb…
5 replies
Hello Everyone I am working on a strange database, as some can tell from my other posts. I need to …
5 replies
EXEC SP_EXECUTESQL @sql, @Parameters, @lColumnValue is there a way to make the third col …
4 replies
Hi, I Successfully Imported the Following XML File ... --------------------------------------------…
2 replies
Viewing 15 topics - 4,591 through 4,605 (of 10,636 total)
You must be logged in to create new topics.