WayneS

Forum Replies Created

Viewing 15 posts - 2,806 through 2,820 (of 5,588 total)

RE: sequence company code dependent through insert triggers

First, create the tables and some initial data. YOU SHOULD HAVE PROVIDED THIS!
-- See how you start off by actually creating a table and then
-- inserting the data 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

October 16, 2010 at 5:35 am

#1237981
RE: Cross query

scottichrosaviakosmos (10/15/2010)
declare @tbldate table(stdid int, sdate date, eddate date)
Now i want to put a condition on my final result column of A and B that if edate is of month...
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

October 16, 2010 at 4:51 am

#1237977
RE: delete running slow

WayneS (10/15/2010)
Michael Valentine Jones (10/15/2010)
Do tables that reference table konten have indexes on their foreign key columns?
Specifically, Do ALL tables that reference table konten have indexes on their foreign key...
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

October 16, 2010 at 4:15 am

#1237974
RE: Help - find values in table 1 NOT in table2

Craig Farrell (10/15/2010)
WayneS (10/15/2010)
Craig Farrell (10/15/2010)
Or, for the 2k8 deprived,
Umm, Craig, this is valid syntax for 2005 also! :w00t:
I think I'm going to go hide in my corner now....
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

October 15, 2010 at 5:22 pm

#1237933
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/15/2010)
GilaMonster (10/15/2010)
CirquedeSQLeil (10/15/2010)
Alvin Ramard (10/15/2010)
For some reason the MythBusters show with the cement truck just came to mind. :w00t:
Epic
Big boom.
That's one of my all-time favourites, along with the...
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

October 15, 2010 at 5:20 pm

#1237932
RE: exporting xml from sql server

LutzM (10/15/2010)
Do you have to store it on the disk?
Why not storing the xml results in a separate table (file name in one column, xml data in a xml column,...
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

October 15, 2010 at 4:19 pm

#1237916
RE: You'd think I'd have learned...

Alan Vogan (10/15/2010)
one lesson I have learned...Don't Change ANYTHING on Friday! Just answer easy questions on SQL Server Central... 😛
SOM!
(They're not so easy when Steve has to go tell...
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

October 15, 2010 at 4:17 pm

#1237915
RE: Help - find values in table 1 NOT in table2

Craig Farrell (10/15/2010)
Or, for the 2k8 deprived,
Umm, Craig, this is valid syntax for 2005 also! :w00t:
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

October 15, 2010 at 4:09 pm

#1237913
RE: delete running slow

Michael Valentine Jones (10/15/2010)
Do tables that reference table konten have indexes on their foreign key columns?
Specifically, Do ALL tables that reference table konten have indexes on their foreign key columns?
You're...
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

October 15, 2010 at 3:52 pm

#1237910
RE: exporting xml from sql server

Either SSIS, OpenRowset (to a text file), or sp_OACreate to use the Scripting.FileSystemObject to write the data out.
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

October 15, 2010 at 3:50 pm

#1237909
RE: Are the posted questions getting worse?

Alvin Ramard (10/15/2010)
Grant Fritchey (10/15/2010)
GilaMonster (10/15/2010)
And just when I thought the situation at That Client couldn't get any worse....
<headdesk><headdesk><headdesk><headdesk>
(No, I'm not going into details, it's a little too sensitive a...
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

October 15, 2010 at 3:07 pm

#1237898
RE: Color coding

Steve Jones - SSC Editor (10/15/2010)
I have awarded back all points and edited the question to include the answer for future people.
Not a great question, and my apologies.
I don't think...
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

October 15, 2010 at 3:06 pm

#1237897
RE: Color coding

William Vach (10/15/2010)
Thanks for the information. I was not aware that you could also set the query window color through the connection dialogue box. I did discover a...
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

October 15, 2010 at 3:05 pm

#1237896
RE: Help - find values in table 1 NOT in table2

SELECT Printer
FROM Table1
EXCEPT
SELECT Printer
FROM Table2;
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

October 15, 2010 at 2:54 pm

#1237893
RE: Are the posted questions getting worse?

Brandie Tarvin (10/15/2010)
Gail,
Isn't your project's "deadline" sometime next week?
That's what the email is about. It was moved up to this week....
(running real fast...)
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

October 15, 2010 at 12:41 pm

#1237810

Viewing 15 posts - 2,806 through 2,820 (of 5,588 total)