Viewing 15 posts - 4,441 through 4,455 (of 9,707 total)
What you might consider is either a subquery, CTE, or TempTable for your initial Tally Table pull. Pull just the numbers from the Tally Table that you need and only...
April 23, 2012 at 5:06 am
This definitely looks like a job for dynamic SQL. The thing to remember, though, is that the PIVOT command requires some sort of aggregation, which may skew the result set.
April 23, 2012 at 4:52 am
Your solution is to either don't use Bulk Insert (use SSIS and trim the data on import) or import the data into a staging table, trim the spaces off, then...
April 23, 2012 at 4:47 am
I am probably phrasing this wrong (and someone will gently tap me upside the head with the pork chop launcher to correct me)...
From what I've seen, SQL has a...
April 20, 2012 at 11:08 am
SQLRNNR (4/20/2012)
Brandie Tarvin (4/20/2012)
Has anyone heard of a company called Kaseya? They apparently do IT software, user conferences, and webinars, but I can't find much more out about...
April 20, 2012 at 8:32 am
Unrelated question:
Has anyone heard of a company called Kaseya? They apparently do IT software, user conferences, and webinars, but I can't find much more out about them - reviews,...
April 20, 2012 at 4:59 am
Grant Fritchey (4/20/2012)
New rule, Threadizens, if you go down at a conference, you have to get word back to another Threadizen. Some of us actually do care (a little).
More than...
April 20, 2012 at 4:56 am
I am starting to do guest posts on my writing blog and I'm wondering if any of you Threadzian authors (who have done editing or writing on SQL Server books)...
April 19, 2012 at 6:31 am
Stefan Krzywicki (4/18/2012)
SQLRNNR (4/18/2012)
Stefan Krzywicki (4/18/2012)
jcrawf02 (4/18/2012)
Stefan Krzywicki (4/18/2012)
Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes,...
April 19, 2012 at 4:24 am
How about a slight change of subject. Still "worst questions" but of the humorous sort.
We've all heard about the admin assistant who switched from typewriters to computers and started whiting...
April 18, 2012 at 12:13 pm
Does that mean you are good to go, or that you still need help?
April 18, 2012 at 11:45 am
In the spirit of bad questions getting posted, here's mine.
I have a "Incorrect syntax near ncp". How do I resolve?
And now I shall hide in the Tent. Guard Hippo, defend...
April 18, 2012 at 11:42 am
Viewing 15 posts - 4,441 through 4,455 (of 9,707 total)