Topics
Started by
Posts
Last post
I have a query that parses and runs in both the query analyser and the view designer, my problem is…
1 replies
Hi all, I have a table, and want to figure how I can return the count values that are greater than …
5 replies
Hullo! I am using xp_getfiledetails to pull back the time and date of last write when I look at the…
6 replies
Is it possible to set the Identity Seed and Identity Increment in T-SQL? I'm in a converion phase …
6 replies
Hi, I would like to know how to run a batch file on a remote W2K/NT box by using xp_cmdshell. Here …
3 replies
Hello all, I have a query that works just fine but it is very slow. This query uses Sub-Selects to …
2 replies
I am trying to investigate a looping process and want control over the spid execution process while…
2 replies
Here are three statements 1.SELECT A.RetailPrice * F.salesQuantity FROM StockDept A ..... Result 29…
8 replies
Can someone show me how to update a table with a field from another table. I have a field to match…
2 replies
Does anyone know how to get the day of week to return from a from a datetime value? For example, h…
2 replies
I have performance problem when I create a select from sql 2000 into sql 7 How can I solve this pro…
10 replies
We have the data for llast 3 years, We would like to run a weekly report for all the data of three …
15 replies
I have to do a LEFT JOIN on two tables. Both fields are the same type (nvarchar) but one table has …
21 replies
I always get time out when i run a query. Mostly i run the query for getting the row number of my r…
2 replies
Dear all, My boss asked me to monitor changes in some tables: who changed what columns with which v…
11 replies
Viewing 15 topics - 14,896 through 14,910 (of 17,082 total)
You must be logged in to create new topics.