If you search the Sql Help documentation you'll probably find this warning.

ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these...

There's not much information to go on. In the rare instances I've had to do this myself I found that the most efficient way is to create a view to...

I'm not sure just what's happening but is it something like:

spProc @Var as varchar(X)

declare @STR as varchar(Y)

set @STR='Insert into Table1 select '+@var+'  ', a.field1, b.field2 from table3...

Forgive the foolish question but in your stored procedure are you attempting to insert a value into this index field? If so remove that potion of the code and try...

PS

I posted that previous reply before noticing you're having trouble getting your script to work properly. I know the between works on dates perfectly because I use it every day...

PS

I posted that previous reply before noticing you're having trouble getting your script to work properly. I know the between works on dates perfectly because I use it every day...

Actually you don't need the time parameter at all if you use:

DEDate between @Dt1 and @dt2

where

@dt1='5/1/06' and @dt2='5/2/06'

will give you everything from midnight 5/1/06 up to...

I take that these statisticts are cumulative, each day more records are added for the same device/interface. If this is the case then select distinct would have to read the...

I'm not really up on constraints but one thing jumps right out at me.

The regular expression '[\-+]?[0-9]+' simply says that this is a either a negative or a positive integer.

This being...

There really not enough information to work with. Reporting Services can throw a plethora of errors that can be considered initialization errors because there are some many seperate componants that...

I'm not sure if I understand the problem but I think you want to scan a string for a day of the week. I'm not sure if the input is...

There's not a lot of detail in the post bu this does sound like a permissions problem. Ask yourself how did you set up your data source to access these...

Report Server connection setup is extremely tricky! This is because Report Server is not an application but five or six, (or more I didn't really count), applications linked together. Here's...

Depending upon how much of this you have to do you may well want to find a  better interface, that being said you might try using your Sql Query Analyzer...

The best way to loop through single rows is to use a Sql Cursor, they are relatively expensive, (slow), to use. I I agree with the previous poster that if...