Viewing 15 posts - 10,531 through 10,545 (of 13,879 total)
Sounds like you want to do the sort in SSIS rather than T-SQL - bad idea. One way or another, you should make the SQL engine do that work for...
August 14, 2012 at 10:43 am
priest Ivan Delic (8/14/2012)
There is something else but I think I could work it out. One of the problem was a thing that I didn't entered few row data,...
August 14, 2012 at 10:40 am
praveen901 (8/14/2012)
How do you execute the above scenario,thats the question.Thank you for having a look...
I'll be honest, I don't know how to execute a scenario.
But if you're asking for a...
August 14, 2012 at 7:47 am
GSquared (8/13/2012)
Don't call the database for each row of data. Use a script object to write each row to a...
August 13, 2012 at 9:35 am
sradez_DBA (8/13/2012)
They are not searching the Database from the UI.The search is on the files.
Granted I don't know all the facts, but I really don't like the sound of what...
August 13, 2012 at 9:30 am
sradez_DBA (8/13/2012)
Thanks for the reply.
Our project involves storing the every detail of a product(example).When the users search for the product from the UI, they get this file which has...
August 13, 2012 at 9:03 am
This is quite an unusual requirement - do you mind expanding a little on the reasons behind it?
August 13, 2012 at 8:48 am
chris 76827 (8/13/2012)
Yeah sorry I appreciate its all done in memory but I was referring to the write back stage.That's pretty much answered my question, cheers.
That does not mean...
August 13, 2012 at 4:38 am
Shadab Shah (8/12/2012)
Jeff Moden (8/10/2012)
Shadab Shah (8/9/2012)
I have come across various section on this website where it is mention that SQL Server is a set based programming language.
My...
August 13, 2012 at 4:34 am
You have outlined your scenario, but have not asked any questions. What, specifically, are you having problems with?
August 13, 2012 at 2:46 am
priest Ivan Delic (8/10/2012)
Thanks for the quick answer.I simply want to copy my data from table2, table3 to table1.
I have about 25,000 records.
Fr. Ivan Delic
Please follow the link in my...
August 10, 2012 at 8:29 am
Abu Dina (8/10/2012)
This isn't my function but I've been playing around with it so it does what the title above says!
Create Function [dbo].[RemoveNonAlphaCharacters](@Temp VarChar(1000))
Returns VarChar(1000)
AS
Begin
...
August 10, 2012 at 8:27 am
halifaxdal (8/10/2012)
Thanks for this enlightening discussion. To get the right result for sure for every time, I think I better put an order by clause for every query I write?
If...
August 10, 2012 at 8:26 am
Eugene Elutin (8/10/2012)
5 - 2 + 3 = 5 + (-2) + 3
Now you can see that it's absolutely doesn't...
August 10, 2012 at 3:18 am
Viewing 15 posts - 10,531 through 10,545 (of 13,879 total)