WayneS

Forum Replies Created

Viewing 15 posts - 5,131 through 5,145 (of 5,588 total)

RE: How do i compare the Tables

SAT_SQL (6/29/2009)
Hi All
This my sution
there are two tables i am mentioning , but there is 900000 records ,
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 29, 2009 at 11:35 pm

#1017379
RE: Are the posted questions getting worse?

Hey gang... I'm looking to take "She who must be obeyed" (in this case, both my wife and mother... ) to Niagra Falls. Does anyone here know anything about this...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 29, 2009 at 5:55 pm

#1017308
RE: Are the posted questions getting worse?

Gianluca Sartori (6/29/2009)
lmu92 (6/29/2009)
I'll do it, assuming you're covering travel and accommodation costs as well. 😀
I'm still offering 5 dollars, better than nothing.
Anyway better than "I want (you) to cut...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 29, 2009 at 8:33 am

#1016867
RE: Are the posted questions getting worse?

Gianluca Sartori (6/29/2009)
lmu92 (6/29/2009)
Referring to the original purpose of The Thread:
Any consultant around ready for some charity work?
This one is perfect for Wayne 😀
:rolleyes:
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 29, 2009 at 8:31 am

#1016864
RE: Are the posted questions getting worse?

GilaMonster (6/28/2009)
Lynn Pettis (6/27/2009)
Okay, you were between 6 and 10 when I learned that in University. Not exactly when or which school I was in when I had my...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 29, 2009 at 8:27 am

#1016858
RE: Making Demands

Well, if it were in a busy city, I'd ask for someone to drive me around.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 25, 2009 at 2:27 pm

#1015603
RE: Return Results over multiple columns

Grinja (6/25/2009)
Thanks very much for taking time to answer. Im still not able to accomplish what I intended
The code I posted produces the results that you requested. What did you...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 25, 2009 at 2:15 pm

#1015593
RE: Bulk Insert issue

itslevel (6/25/2009)
hi
can you please help to me
how to import fixedlength file into sql server
please help to me
Advance thanks.
Rajan
Hey Rajan, why don't you start your...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 25, 2009 at 7:12 am

#1015280
RE: Bulk Insert issue

hi_abhay78 (6/25/2009)
can you share the command you are using and other relevant information please.
CREATE TABLE #RawData (LineText varchar(max))
BULK INSERT #RawData FROM "MyFile"
I've tried:
BULK INSERT #RawData FROM "MyFile" WITH (LastRow =...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 25, 2009 at 7:11 am

#1015279
RE: Return Results over multiple columns

This ought to get you on the road...
select Client = c.Name,
Bank1 = max(case when b.bid = 1 then BID else NULL end),
...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 25, 2009 at 1:15 am

#1015113
RE: Are the posted questions getting worse?

For those that use the FireFox web browser (you can stop reading now Jeff:-)) - what do you use for blocking ads? The one I used wrecked havoc on this...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 24, 2009 at 7:52 pm

#1015032
RE: Return Results over multiple columns

Thank you for the code - it makes helping out so much easier.
The #tempClient table looks pretty straight-forward. That's not the case with the #tempBank table. Normally, I would say...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 24, 2009 at 6:14 pm

#1015007
RE: Returning the first value of a field in a grouped resultset

lmu92 (6/24/2009)
@Wayne: When the request is to get the values for more than one Callernum, I'd go with your solution, but I would change
ROW_NUMBER() OVER (PARTITION BY Callernum order by...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 24, 2009 at 5:53 pm

#1015004
RE: how to avoid rownumbers for duplicates

Sounds like either the group by function (like Lutz mentioned), or the use of the windows ranking functions will do the job. And, like Lutz mentioned, we need more information...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 24, 2009 at 2:19 pm

#1014927
RE: Using a UDF to provide a value for an insert statement

Whilst I won't pretend that I know your system better than you, might I suggest you change the way that you are doing this?
If you put your varchar values into...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

June 24, 2009 at 2:10 pm

#1014920

Viewing 15 posts - 5,131 through 5,145 (of 5,588 total)