Viewing 15 posts - 766 through 780 (of 859 total)
chandrika.r 91171 (3/27/2012)
It does not return any error when i ran in SSIS. The package is stored in the file system.
i would import it into msdb and try the job...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 29, 2012 at 10:50 am
naravetlasri (3/29/2012)
I am new to this SQL,and I am practicing some online examples where I got stuck with one of the excercise .
here is the Question
In which years was...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 29, 2012 at 10:33 am
Leon Orlov-255445 (3/28/2012)
RedGate's SQL Compare does the wonders 😉The tool well worth every penny/shilling.
~Leon
at my shop we had to track DB changes from one version of a product we use...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 28, 2012 at 5:03 pm
SQLRNNR (3/28/2012)
Change your query
you almost never want the aggregate your creating in your group by. it basically gets rid of any aggregation.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 28, 2012 at 5:01 pm
shnex (3/28/2012)
I just needed an idea on how should I approach differently the query, more optimized. I will try it with your suggestion.Thank you
no problem. self joins can get...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 28, 2012 at 4:59 pm
you might try "/n" for your row terminator. that seems to be what the first error is complaining about. after that the additional errors may be generated because...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 27, 2012 at 2:48 pm
i got this from the following link.
Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. When...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 27, 2012 at 2:20 pm
Triality (3/27/2012)
I have a table with a bunch of sales orders from different channels (Example: Retail stores, online orders, other). I want to the output of my query...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 27, 2012 at 2:08 pm
djustice 20821 (3/27/2012)
ALTER DATABASE DB
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
GO
DROP DATABASE db
GO
and the error that I got:
Msg 5064, Level 16, State 1, Line 1
Changes to...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 27, 2012 at 11:37 am
SQLKnowItAll (3/27/2012)
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 27, 2012 at 11:26 am
with out DDL and sample data from the UserID table your populating your temp tables from it would be a little tough. This may work though:
SELECT u1.userID FROM Users...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 27, 2012 at 10:47 am
njdevils39 (3/26/2012)
capn.hector (3/26/2012)
We need the DDL and sample data. im supprised...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 26, 2012 at 4:03 pm
im amazed at your patience sean. im sitting here laughing. ill save you at least one time.
We need the DDL and sample data. im supprised you are...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 26, 2012 at 3:47 pm
since no one has posted yet and im not seeing any other way than a loop (i am new at this) you can try this: load the file using...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 26, 2012 at 1:52 pm
I think you are on the right track. get your update query written with the join then as you suggested update X number of records at a time till...
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
March 26, 2012 at 1:33 pm
Viewing 15 posts - 766 through 780 (of 859 total)