Well, I don't need it at all 🙂

but as to the original question, no, I don't think this would help. There are MANY such tables created, all with the...

Problem is that you still need to know the name of your table variable, you can't pass it in as a parameter... and that is what sol was asking. I...

"Note that I'm only creating a clustered index, and I'm doing this on this "scratch" table to order the data for a more efficient means to validate account numbers in other tables."

Depends...

I don't know enough about hardware issues, especially not about SAN, but I know that we had precisely the same problem. Started with Raid 5 and tempdb on the same drive...

There can be no ideas about this. This is impossible in SQL Server. You have to use name of the table directly in your code. If you want to have it dynamic,...

Hi Josh,

If the sequence number really contains customer, and "highest sequence number" takes into account the entire string (custome+seq.no.) then it is as easy as JDixon posted - but I...

Hi Josh,

please could you put the logic into words? I'm not sure what precisely you are trying to do ... here is one way how to understand and interpret it...

Dear shashi,

it may be just bad choice of words caused by the fact that English is not your native language, but your remark is not very friendly or polite... I don't see...

Hi Jay,

the part you are trying to run by itself contains BEGIN, but no END. If it isn't just a typo when posting, this is why the syntax error appears.

I almost posted the same... but then ran a test and realized that this really isn't the problem. Using a style (like 101 or  103) with CONVERT overrides dateformat setting....

Because you have instructed SQL Server to convert using style 101, which is mm/dd/yyyy. That is, you are trying to create a date with month 15.

Use

select convert(datetime,'15/11/2006',103)

FLOAT is a very special datatype and so far I never needed to use it. I always use MONEY or NUMERIC datatype, depending on requirements.

It would be nice to know...

Hi,

I tried to run your select, but it gives me error message:

Incorrect syntax near the keyword 'join'.

(What I mean to say is, what you posted does not specify much about...

Ninja has covered the question, I have just one more thing to add : it is recommended to use YYYYMMDD format when entering dates (without any delimiters). This is the...

Don't be sorry I can understand you very well... and btw, my original "solution" was pretty stupid, since it only worked well when...