Topics
Started by
Posts
Last post
I'm building a procedure which will create records of inventory items to be counted over a 2 year p…
9 replies
I was tweaking some queries, and noticed a high cpu usage on some of those. It then occured to me, …
6 replies
I'm sure this has been asked before, but I can't find it anywhere. I want to select a record based…
6 replies
Table A:- ID(P.K),ADD,STREET# Table B:- ID(P.K),LNAME,FNAME,ADD,L_ID(link to Table A) QUESTION:- Ho…
15 replies
Pff, can't get it to work. I have a SP in master, and it runs some checks on a db but it should als…
3 replies
Dear All, I am new for SQL XML programming I want to extract data from SQL tables to XML file in t…
2 replies
I have one table with a few columns that may be NULL, like this: COL1 COL2 COL3 1 AA …
1 replies
Hello. I just need a simple description of this query and its function. ROUND(DATEDIFF(d,'12/01/2…
5 replies
I having a view which returns nearly 80 thousand records in 1 min which is very slower. View has jo…
5 replies
I know I can use SSMS to script DB Objects. However, is there a command line utility or version? I …
5 replies
Ok, so I have two simple queries, one returns rows, and the other one does not --this returns one r…
6 replies
Hi Guys, Just a small one this time. I have a table which contains household insurance quotations. …
20 replies
I have tow tables thus: TABLE_A PCode MonthPop 5F5400000 5F7777777 5HG222224 5HP153086 - TABLE_…
2 replies
Using the below query i get the following results 2010-07-01 00:00:00.000 2010-10-01 00:00:00.000 H…
8 replies
HELP! I have a DTS package that's been running for 4 years pulling data out of our ERP system runni…
1 replies
Viewing 15 topics - 2,761 through 2,775 (of 12,234 total)
You must be logged in to create new topics.