Topics
Started by
Posts
Last post
Hi, I'm using SQL Server and I am trying to convert some ASP code I wrote into a User Defined Funct…
20 replies
I have an sp that truncs a table and then inserts new rows. The sp takes over 2 minutes to in…
7 replies
Hi guys, I have a problem Select * from table where col1 = 'somevalue' My question is: Can I use th…
13 replies
How do I move a varchar string like '2004-05-13 00:00:00.000' into a datetime column when…
19 replies
We have SQL Server 2000 SP3. I have records as shown below Country &n…
8 replies
The tricky part is that i need to cascade this to the child tables. pseudo code: If records exists …
3 replies
I asked question this at another forum and the answer was there is no difference because the optimi…
4 replies
Howdy. This may be a simple question, but I can't figure a way to describe it in Googlish terms. se…
4 replies
Dear all I have the following code in a stored procedure:- @priceMin int, @priceMax int AS BEGIN …
8 replies
I have a stored procedure that has several update statements in it and when I run it against a tabl…
4 replies
This was a nightmare procedure and you guys helped me with it last time. I added the split function…
6 replies
This query takes quite a while to run and I'm wondering if there is anything I could do to speed it…
8 replies
I have used Joe Celko's model of Nested model. Now I want the following query. I …
5 replies
is there any way to improve performance on queries that SELECT * without WHERE conditions? Inde…
8 replies
Hi all how can i add another where clause to this sql statement? i need to add a second set of colu…
4 replies
Viewing 15 topics - 6,751 through 6,765 (of 17,082 total)
You must be logged in to create new topics.