Topics
Started by
Posts
Last post
Is there an sample script to drop the "MS_Description" of all tables and all columns in my databas…
1 replies
suppose I have a table that store the values of zip codes and sales tax rates for each zip code. Le…
2 replies
How do you stop a script from continuing execution? I tried using RAISERROR(), but the script does …
4 replies
Hi, I use SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0…
2 replies
As the lead developer for our (small) company, I am too often pulled into customer support calls fo…
4 replies
Hi all, Let's say I have an Orders table with rows identified as open or closed depending on the va…
6 replies
Consider this: declare @amount decimal(16,2) declare @periods int set @amount = 0.30 set @periods =…
7 replies
Hi All I am trying to write a select statement that has to return data from fields that might not b…
10 replies
Hi All, I have to compile some 30-40 stored procedures at the client end. Currently I am do this by…
4 replies
I need to traverse up to the top of a hierarchy given one or more child ID's, and then traverse bac…
3 replies
This is the table DDL: CREATE TABLE index_time ( Starttime DATETIME, ENDtime DATETI…
2 replies
I'm sending a notification email in HTML format and there is data in a table function type i want t…
2 replies
HI All, I was reading an article a few weeks back but can't seem to find it anymore so thought I'd …
6 replies
I have 2 tables: 1."Employee" which has 20 odd fields. 2."User" has 80 odd fields. When a record is…
2 replies
Hello I am using the following query, of which I want to also get the sum total of order totals fo…
1 replies
Viewing 15 topics - 8,761 through 8,775 (of 12,230 total)
You must be logged in to create new topics.