Viewing 15 topics - 258,256 through 258,270 (of 284,026 total)
Topics
Started by
Posts
Last post
Dear Friends, How do we sort a varchar field if the field contents doesn't have a format in numberi…
23 replies
Gurus, I've written many successful update statements to update a field based on a value in an…
8 replies
Hi, I have created a DTS package. Purpose of the package is to create the required tables and inser…
2 replies
I have a database that is made up of 4 data files. I have a complete backup and want to resto…
1 replies
select order_origination,count(1) from orders --with (index(dt_rcvd)) where dt_rcvd between '2004-1…
9 replies
I'm ready to roll off data from partitioned tables but the delete will cross partitions unioned by …
4 replies
I've got a view that basically consists of subqueries to get rollup information. It doesn't transla…
2 replies
I am setting up a Database Maintenance Plan. I have a question about the sequence in which I should…
2 replies
A scheduled DTS job will not complete because it is requiring the Lotus Notes password to be entere…
1 replies
My problem is as follows: I have four views which are all simple select * from table stateme…
3 replies
We are currently running an application on a Windows 2000 Server box. The machine is using SQL Serv…
5 replies
I am trying to query a field in a table named 'Function', but I get a syntax error. I realize…
1 replies
I tried to alter a table using SQL Query Analyzer and clicked the "Parse Query" to verify the …
11 replies
What are the guidelines to avoid sql injection in stored procedure. I know if using dynamic sql sat…
31 replies
Does anybody know anything smarter than repeating a formula like this: select case&nbs…
3 replies
Viewing 15 topics - 258,256 through 258,270 (of 284,026 total)