ryno-544382 (7/3/2012)

---

Hi,

Thanks for taking the time to get back to me.

I have updated the post to make more sense and per your suggestion.

If there is anything I still missed please...

That value is outside the range of what can fit in a float.

http://msdn.microsoft.com/en-us/library/ms173773.aspx

The title of your thread talks about creating tables...

This is excellent Dwain!!! Definite addition to the toolbox.

There are a lot things it could be. Parameter sniffing, stale statistics, blocking, poor indexing...

Take a look at this article about how to post performance issues.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

I am by no means well versed in Oracle but my goggle-fu isn't too bad. I used the default constraint of SYSTIMESTAMP on the table and found the Oracle info...

gmamata7 (7/2/2012)

---

Thanks Sean,

I understand how to create alias but got confused where to configure i.e on sql server or on client computer:

from the link http://msdn.microsoft.com/en-us/library/ms190445(v=sql.105).aspx

It says, we need to set...

I think you will far better luck with a flash forum for issues with flash. I suspect that those forums will have the same general complaints about your post unless...

Not sure really what you are asking but I found this article which explains how to setup an alias.

http://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/%5B/url%5D

It doesn't really make sense to have the alias be on the...

I believe you want to use the datetimeoffset datatype.

http://msdn.microsoft.com/en-us/library/bb630289.aspx

I think your default constraint would just be getdate().

You can use SQL search, the free tool from redgate. It should search just about anything you listed although I am not sure it will find t-sql in a job.

Here is an interesting list, many I have never heard of before.

http://en.wikipedia.org/wiki/List_of_dates_predicted_for_apocalyptic_events

Bill Talada (7/2/2012)

---

@ Lynn Pettis

I don't remember you posting code for your 8k splitter. We all knew there was a general splitter function being used. It doesn't matter...

ChrisM@Work (7/2/2012)

---

Sean Lange (7/2/2012)

---

You will find far better performance and code maintenance by creating a sproc for each of your different select statements. The code dwain posted is indeed quite...

You will find far better performance and code maintenance by creating a sproc for each of your different select statements. The code dwain posted is indeed quite a clever way...