Topics
Started by
Posts
Last post
If a query has several OR statements will it check for all the OR statements or will it skip checki…
12 replies
I know people frown on dynamic sql, and if someone else has a better idea, please let me know, but …
4 replies
Hi all. (SQL Server 2000) Can someone please help me with the following problem: - I have a …
3 replies
Hi friend in sql2000 is possible to script out all dts by using enterprise manager??? i know that i…
1 replies
I have a slight problem with a full-join query which is based upon sub-queries. I have two tables c…
9 replies
Hi I want to make change in user defined datatype ? Could u pls help me to …
2 replies
I have three tables: Invoice, InvoiceCharge, and InvoiceResponse Invoice pk name I1 Dan I2 …
4 replies
Hi, Any suggestions on how to trim the decimal places off: 1,234,567.00 >> 1,234,567 &nb…
4 replies
Hi Folks, Having trouble using a local variable in the FROM section of a SELECT statement (not sure…
3 replies
Hi guys, There are same way to know what Stored Procedure calling my actual SP. When I use @@NestL…
2 replies
Hi All, I've got a table here (sims.sims_member) with person_id in it. I need to loop through it an…
1 replies
hiii, Befor opening a cursor, I want to check whether it is already open or not?? How shud i chk it…
7 replies
Have a stored proc with following logic: - create global temp table - insert into temp table a sele…
12 replies
I am currently trying to find the best way to update information in multiple tables of the same dat…
6 replies
hi, I'm pretty new to stored procs and at the moment im trying to put one if statemen…
4 replies
Viewing 15 topics - 10,726 through 10,740 (of 17,082 total)
You must be logged in to create new topics.