Viewing 15 posts - 18,241 through 18,255 (of 26,489 total)
Or to use BULK INSERT in T-SQL. If the file is a CSV this should be relatively easy to accomplish.
November 23, 2009 at 1:19 pm
I do have one request, please put together a small dataseet for each of your tables along with expected results based on the sample data so that when I put...
November 23, 2009 at 12:49 pm
I don't have time right now, as I am at work, but if others will let me I'll take what you have given here and work up a set-based solution...
November 23, 2009 at 12:46 pm
Well, I do need to ask a question. Why are using a cursor? Depending on what you are doing, it is probably 99.9% possible to replace your cursor...
November 23, 2009 at 10:47 am
This one makes you wonder about some people.
November 23, 2009 at 10:40 am
I guess we all forgot The Thread's birthday. Think It will hold that against us?? 😉
November 23, 2009 at 10:31 am
hydbadrose (11/23/2009)
IT should be in any system views. The other DMV's are there but this one. Please help me finding this Sys.dm_db_index_physical_stats dmv.
It isn't a VIEW, it is a FUNCTION....
November 23, 2009 at 10:15 am
You are probably looking in the wrong place. It isn't a system view, it is a system TVF.
November 23, 2009 at 10:05 am
There is this function, YEAR().
SELECT YEAR(GETDATE())
November 23, 2009 at 9:04 am
Don't have anything for you with regard to SSIS, but I do have a suggestion regarding the query you posted:
SELECT
InteractionID,
StartRecord,
...
November 23, 2009 at 7:43 am
bmw110001 (11/23/2009)
Cannot find the principal 'ima-ind_dbuser', because it does not exist or you do not have permission.
And? A question you may have?
November 23, 2009 at 6:46 am
As you are creating a CSV file on a daily basis, this sounds like a job for an SSIS package. I'd like to recommend that you look into that...
November 23, 2009 at 6:45 am
And it also depends on how the query is written as well. A straight SELECT query from a Tally table for instance all the values were the same for...
November 22, 2009 at 10:50 am
Jeff Moden (11/21/2009)
Understanding is the key... thanks, Saurabh. :blush:
Actually, Jeff, in a query such as this:
select getdate(), getdate();
the getdate() function is actually called twice. Found this out during...
November 21, 2009 at 8:14 pm
Unfortunately, you really didn't answer Seth's question. But regardless, please check out my blog post here.
November 21, 2009 at 8:09 pm
Viewing 15 posts - 18,241 through 18,255 (of 26,489 total)