Topics
Started by
Posts
Last post
G'day, I'm trying to use distinct to give me a specific result set. What I want to do is pull only…
6 replies
Hi everybody! Is there a SP that can help me search for the content of a field in a DB. I have here…
3 replies
Hi, I have a stored proc which tries to obtain the last transaction history record for each custome…
1 replies
My customer has two databases. what he wants to do is enter data in one database and insert, updat…
1 replies
Hello - Why must I use "non-Ansi" join syntax in the inner query of a correlated subquery. i.e. Thi…
11 replies
SELECT * FROM OPENROWSET('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:\;','SELECT…
8 replies
Dear All: Please tell me how to solve below problem? Please help, thanks! -- Table Data create t…
6 replies
I would like to create an xml file using SQL and then want to update that file accrding to the requ…
1 replies
I Have two tables Structure is as below M_Brochures (Pid Brochures) M_Holidays (pid Holidays Brochu…
2 replies
Hello, Does any one know of some T-SQL that returns a date time when a table was last accessed??? …
4 replies
Hello all. I know that I read something about this conversion issue a few weeks back, but couldn't …
9 replies
Hello! Just two quick questions. From BOL: quote: Although a unique index will help locate informat…
2 replies
HI ALL Lets say I have a "users" table and a "GroupOfUsers" table relaed by Group ID, many users …
3 replies
In a T-SQL script, how do you write you results to a file? Right now I'm using "print" to display t…
4 replies
I'm trying to pass in a set of values into a select statement in a SP. Unfortunately, I can't decla…
4 replies
Viewing 15 topics - 16,426 through 16,440 (of 17,082 total)
You must be logged in to create new topics.