All that's going to do is set taxid to 1 for all records inserted. You don't need to use a cursor, either - it's a bad idea from a...

mandirkumar (3/12/2012)

---

As requirement owner says there is no much flexibility in SSIS as in T-Sql query, so decided not to use SSIS, as I know BCP and others are used...

Search for tally (numbers) tables on this site. You can either create a permanent one, or you can do it on the fly with a CTE. Once you...

All that's going to do is set @followingdate to tomorrow's date 30 times, but not display anything until the end. Please will you show what results you expect to...

Does that not make you curious to find out what results are being returned? Try this:

SELECT convert(varbinary, C.X_stat) & 32

FROM C

John

I'm surprised it says it's incompatible with int. Have you tried CASTing or CONVERTing?

John

You're doing it outside of SQL Server, so you don't need to connect. You just need to check whether the service is running. There are a number of...

Without table DDL (including foreign key constraints), we're just guessing. But all you need to do is add another INNER JOIN clause similar to the existing one. The...

You'd need to handle that outside of SQL Server. There are monitoring tools that will alert you when services change state. If you want to do it yourself,...

Because, as Gianluca and BrainDonor have already mentioned, you need to use a split function or dynamic SQL. Make sure you understand the implications of the latter.

John

Going to Simple recovery option may not solve this problem: if the log file is filled by a single transaction then it doesn't make any difference how often it's cleared.

TRUNCATE...

I believe so, but the only way to know for sure is to test it.

If your primary key is subject to change in the way you mention, you may consider...

Well, I don't know why it's working for me but not for you. Please will you run this and post the results:

SELECT

name

,OBJECT_NAME(parent_object_id) AS fk_table

,create_date

,modify_date

FROM

sys.foreign_keys

John

A stored procedure would probably be a good idea. You'll need to use dynamic SQL if it's going to run against different tables, so make sure you understand the...

OS error 32 means the file is already in use by another process. Could it be anti-virus software, or another SQL Server instance on the same computer? You...