Topics
Started by
Posts
Last post
Hello all, I want to find the share of sales % for each sales item. Fox example, Sales item can be …
4 replies
I'v setuped a Oracle8.16 linked server througth oracle oledb provider: OraOLEDB.Oracle. When I use …
4 replies
Let's say you create a table with a foreign key constraint declared, but forget the cascade delete …
6 replies
We have a table name stored in a variable. So far we've needed dynamic SQL to execute queries again…
4 replies
I just noticed that a lot of our newsletter subscribers seem to have had their emails mixed up by o…
2 replies
I am importing a text file into a temp table every 15 min. and want to compare two fields, PINChang…
2 replies
I was hoping someone could help on this one... Here is my statement: select * from test_td a, test_…
7 replies
I believe the I saw a function that would do this but don't remember what it is.... can anyone help…
7 replies
Watch out for this one in SQL7! select isnumeric('4,668.90') ...returns 1 as it is numeric select c…
2 replies
Hi, I have a table that one of its fields type is text. i want to insert a new record to this table…
5 replies
I am using SQL Server 2000 (Developer's Edition), and have attempted to copy one record from Table …
22 replies
Is there a way to calculate STDEV across several columns in a stored proc or UDF? i.e.: STDEV(Col1,…
6 replies
I have a following update statement in SP and I am sure that it can be tidyed up i just don't know …
1 replies
HI ALL I get a array in vb of lets say 300 numeric elements. For each numeric element I should i…
12 replies
Hi Folks, I am having a problem with a sp that using dynamic SQL quite heavily. Everything has been…
5 replies
Viewing 15 topics - 16,216 through 16,230 (of 17,082 total)
You must be logged in to create new topics.