Viewing 15 posts - 856 through 870 (of 5,504 total)
You didn't mention anything about the parameter @timeline, just three scenarios...
Based on more than 500 points on your side I would have expected you know how to provide ready to...
November 24, 2011 at 1:32 pm
see my reply on your original post.
November 24, 2011 at 1:00 pm
Maybe one reason for not getting an answer yet is the holiday in the U.S. ....
Another reason might be that "timestamp" refers to a "unique binary number within a database"...
November 24, 2011 at 12:59 pm
November 23, 2011 at 2:42 pm
Revenant (11/22/2011)
jdrintnt (11/22/2011)
Can someone point me to an article or white-paper with more info on reading Excel XLSX files into SQL Server, and writing them back out again...
November 22, 2011 at 11:28 pm
To repeat what I stated before:
To load an Excel XML file into SQL Server you could use a linked server, OPENROWSET or XML bulk load. Which one to use depends...
November 22, 2011 at 4:45 pm
krypto69 (11/22/2011)
...Is there a way in SQL to have as part of my query the column names enumerated (numbered in order)?
Simple answer: no. And that's just because there is no...
November 22, 2011 at 2:06 pm
Can you provide an example of what you're trying to accomplish?
(E.g. sample of the normalized table and the final Excel result including an explanation of the transformation rules).
To load an...
November 22, 2011 at 1:45 pm
If the major issue is the export time into Excel you might look into changing this method before completely rewriting the code:
Do you have some sort of WHILE loops that...
November 22, 2011 at 11:49 am
Evil Kraig F (11/15/2011)
Ninja's_RGR'us (11/15/2011)
Someone can cover for me here... need to go!ttp://www.sqlservercentral.com/Forums/Topic1206207-1549-1.aspx
Linkie no workie
Try this one: (included the leading "h")
http://www.sqlservercentral.com/Forums/Topic1206207-1549-1.aspx
November 15, 2011 at 12:05 pm
SQLRNNR (11/14/2011)
Steve Jones - SSC Editor (11/14/2011)
Gianluca Sartori (11/14/2011)
Congrats Jason for winning T-SQL challenge 63!+1, congrats
Danke
Herzlichen Glückwunsch! 😛
When did they start to allow solutions other than a single query?
(It's been...
November 14, 2011 at 12:26 pm
Are the databases on the same instance or will it query data off a different instance/server?
It seems like the view needs some tuning (or even using a divide'n'conquer approach).
Can you...
November 13, 2011 at 3:24 pm
Can you connect to the database using Management Studio and logon as the test user you're trying to use with ACCESS? (First step: figure out if it's a SQL permission...
November 12, 2011 at 12:38 pm
It seems like there's no clustered index on the table.
Based on the information provided so far I recommend to make cmmac the clustered index.
After that, rerun the query and post...
November 12, 2011 at 3:07 am
Look up sp_helprotect in BOL. It should return what you're looking for. But keep in mind that it "does not return information about securables that are introduced in SQL Server...
November 11, 2011 at 1:52 pm
Viewing 15 posts - 856 through 870 (of 5,504 total)