look at the error you are getting; it should be very obvious;

if i used your function for a table named "Customers" and a WHERE statement that was "CustomerName LIKE 'c%'

what...

ricky i'm just confirming what you are seeing; for me so far, if the try catch is in a transaction or using a transaction, i get the same failure; I...

In SQL you have to use dynamic sql and the EXEC(EXECUTE) statement.

Oracle is the same, but you would use EXECUTE IMMEDIATE,

ie execute immediate 'drop table TEMPTBL';

it...

raju you are very welcome; you should get some other great feedback as other posters get their coffee and hit this thread as well.

ahh gotcha Satish; a zip+4 database is a little different. i think the issue becomes "that's my proprietary data" that if someone cloned, they could build their own app for...

not enough info i think Satish; still a lot of variables out there;

your database is 30 gig, but if i were a client of yours, how much of that data...

raju i can only tell you my experiences and the way we do things at my shop; you can review them and see what you like, since there's no real...

oracle is double pipe; SQL Server uses the plus sign, and will only concat the char datatypse(char/varchar/nchar/nvarchar); so of you need to concat an integer to the string , you...

Joel you are on the right track; you'll need to join against another table, but it doesn't necessarily need to be a real calendar table. you can use a Tally...

change the backup command so instead of NOINIT it says INIT:

NOINIT=append to existing

INIT=replace if exists:

USE MASTER

BACKUP DATABASE [MSPHXX]

TO DISK = N'K:\MSPHXX_ARC.bak'

WITH NOFORMAT, INIT, NAME = N'MSPHXX_ARC',

SKIP, NOREWIND,...

itskumar2004 (2/1/2010)

i know the syntax dateadd(month,3,datefield) which will add 3 months and you can only see one month..

but i want a syntax to see all next 3 months of...

ugg; i didn't even look at the question, just tried to create the data in a ready to consume format;

help us help you! in the future, try to give everyone...

Steve it sounds like you could prevent it to me.

If you can detect data that does not belong AFTER the fact, you could add filters in the application or in...

mark i believe you can also change the function to return a table value function, and use CROSS APPLY to apply it against your data for a big performance gain.

Lynn...

no the virtual tables are stiull there, but in an INSTEAD OF trigger, it's up to you to do something with the results; if you sent an did some buiz...