Topics
Started by
Posts
Last post
Hi All, Not sure if this should maybe have gone under the discussion section but here goes. I have …
7 replies
I want to write a common function or stored procedure to which I want to pass as variables, table n…
4 replies
I am trying to write a stored procedure that takes a number of integer values and runs a query on t…
10 replies
I'm trying to take the date from one field, minus a year from it and then add a day to it. Example:…
3 replies
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
Viewing 15 topics - 8,761 through 8,775 (of 12,234 total)
You must be logged in to create new topics.