Viewing 15 posts - 10,111 through 10,125 (of 26,489 total)
santa326 (8/14/2012)
yes i can do that but,how will sql know that my text is in dd/mm/yyyy for and not in...
August 14, 2012 at 12:04 pm
You mean something more like this?
CREATE TABLE [dbo].[tst_InvoiceHeader](
[invoice_id] [int] NULL,
[grouo_id] [int] NULL,
[subscriber_id] [int] NULL,
[createdate] [datetime] NULL,
[duedate] [datetime] NULL
) ON [PRIMARY]
INSERT INTO dbo.tst_InvoiceHeader
( invoice_id ,
...
August 14, 2012 at 11:55 am
rVadim (8/14/2012)
August 14, 2012 at 11:47 am
santa326 (8/14/2012)
Hi,Have you gone through the following post.I had a similar problem.
http://www.sqlservercentral.com/Forums/Topic1322992-392-1.aspx
Regards
Ravi T
Make it easy on others:
http://www.sqlservercentral.com/Forums/Topic1322992-392-1.aspx
August 14, 2012 at 11:32 am
David92595 (8/14/2012)
Either one works, I prefer to define/ know the exact time the query will be using. Which include the time being 11:59:59...
The way I showed above does the...
August 14, 2012 at 11:28 am
Charmer (8/14/2012)
Lynn Pettis (8/14/2012)
August 14, 2012 at 11:16 am
David92595 (8/14/2012)
First Day of...
August 14, 2012 at 11:07 am
I'd like to see the query, tables and indexes, and the actual execution plan of the query. Never know, there may be some tuning that can be done.
August 14, 2012 at 11:02 am
Grizzly Bear (8/14/2012)
Microsoft has this article http://support.microsoft.com/kb/2002606
But that...
August 14, 2012 at 10:53 am
The other option is to use a SQL Task to load the results of your query into a staging table (permanent or temporary, but probably permanent for ease of coding)...
August 14, 2012 at 10:49 am
SQLKnowItAll (8/14/2012)
August 14, 2012 at 10:45 am
Charmer (8/14/2012)
Lynn Pettis (8/14/2012)
Have you tried tuning your SQL query?Yes, Lynn...my SQL query has no other way....this is it...:(
Not sure what you mean by "has no other way."
August 14, 2012 at 10:35 am
Kwisatz78 (8/14/2012)
http://msdn.microsoft.com/en-us/library/ms177440(v=sql.100).aspx
It mentions to right click and select properties to...
August 14, 2012 at 10:30 am
Viewing 15 posts - 10,111 through 10,125 (of 26,489 total)