Topics
Started by
Posts
Last post
I am having a problem when analysing a sum with data from 2 x tables (ITEMS,CUST): I want to do the…
12 replies
Hey all I have 3 tables, I need to marry data from 2 of them into the third. SHOULD be…
4 replies
hi need help how can i update field in Table only if exist like this --------------------------…
2 replies
I have put an individual DB into single user mode by executing the following: ALTER DATABASE dbName…
5 replies
Hi I need to display the list of rows in CSV formated result set Eg. MyTable ColA …
7 replies
As a beginner in sql im having trouble understanding the date and time functions.Could someone expl…
12 replies
So - I have a good one for you guys.... I have stored proc that takes in 2 date parameters - @start…
11 replies
Why does this not work? INSERT INTO dbo_Versuchsart VALUES (SELECT * FROM AuswahlVersuchsart) Her…
9 replies
Ideally, it would have a default of getdate(), but since that's non-deterministic, I need to requir…
3 replies
hi, i copy/pasted the actual code of the SP below. can anyone translate it into something tha…
4 replies
I have a table (n), the table n keeps string SQL statement: CREATE TABLE N ( ID INT, strSQL VARCHAR…
7 replies
Guys, Does anybody know if there is a function that can be used to rank the results sets in TSQL? &…
4 replies
Hi All. Here is my situation. I've inherited a database that was created by a 3rd part…
2 replies
I am really puzzled by this one. I have two servers: Server1 and Server2. Server2 is de…
11 replies
From what I understand I should try to create a clustered index on all tables in the DB. Having an …
4 replies
Viewing 15 topics - 9,766 through 9,780 (of 17,082 total)
You must be logged in to create new topics.