Topics
Started by
Posts
Last post
this is the code we have and just want to know if there is any better way of writing it CASEWHEN P…
1 replies
Hi there, I have a stored procedure that inserts data into a linked server's table if the data does…
5 replies
Here are the tables involved: MachineName table has two fields: machineName and machineID MachineAu…
26 replies
Ack... I'm not even sure which forum to post this question on because it's way outside what I norma…
5 replies
Hi, I want to create an index in an UDF. I've read one article that creates an index with schemabin…
11 replies
I want to get all the columns from the record with the most recent order date (out of n records). I…
4 replies
I accidentally posted this in the 2005 forum. This db is on a 2000 server, so I need a work around …
4 replies
hi friends i have a procedure named 'UpdateTable' with an input parameter named @xml. @xml is nvarc…
2 replies
Hello! I have this kind of data (about 40 000 rows) id; keywords 1;horse, red, farm 2;cat, white, …
3 replies
We have an ERP system. I have been asked to extract (for migration purposes) Products & Struct…
4 replies
Dear all, i need to display dates as a O/P which falls between two date inputs . Eg: input …
19 replies
I have a table I'm using for site navigation. I can query the top level pages by checking to see if…
5 replies
Hi all, this is not an urgent question, it would however make a few processes here a fair amount si…
14 replies
Code below works great and pulls data in query Analyzer but when I insert into a transform data tas…
3 replies
SELECT a.* FROM OPENROWSET( 'SQLOLEDB', 'Trusted_Connection=yes;Integrated Security=SSPI;DataSource…
13 replies
Viewing 15 topics - 2,116 through 2,130 (of 17,082 total)
You must be logged in to create new topics.