WayneS

Forum Replies Created

Viewing 15 posts - 226 through 240 (of 5,588 total)

RE: PIVOT situation-- String Value in Aggregate columns

Joe-420121 (9/19/2015)
Hello Livingston, thanks for your reply, the table should look like as below data,
-----------------------------------------------------------------------------------------------------
(1, 'Col1', 1, 'ILove' ...
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

September 22, 2015 at 3:49 pm

#1828603
RE: Are the posted questions getting worse?

Ed Wagner (9/22/2015)
Alvin Ramard (9/22/2015)
Lynn Pettis (9/22/2015)
Alvin Ramard (9/22/2015)
Lynn Pettis (9/22/2015)
Alvin Ramard (9/22/2015)
Grant Fritchey (9/22/2015)
jasona.work (9/22/2015)
I think I need an intervention...
I keep going back to the "Jet" topic, it's like...
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

September 22, 2015 at 1:36 pm

#1828564
RE: Are the posted questions getting worse?

Lynn Pettis (9/22/2015)
Looks like I am going to get thrown into the deep end on some blocking issues with our main product. Having been working in relatively stable environments...
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

September 22, 2015 at 11:53 am

#1828517
RE: Dynamic SQL without Dynamic SQL?

BOR15K (9/22/2015)
Sorry for a bit confusing topic, but need your advise, please.
I have old good stored procedure, doing quite complex SELECT FOR XML and all is perfect.
that SELECT has rows,...
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

September 22, 2015 at 5:05 am

#1828322
RE: Similar quires produce different output !! why ?

squvi.87 (9/22/2015)
create table #t1 (id int)
create table #t2 (id int)
insert into #t1 values (1)
insert into #t1 values (2)
insert into #t1 values (3)
insert into #t2 values (1)
insert into #t2 values (2)...
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

September 22, 2015 at 4:28 am

#1828317
RE: "send me some of your code"

pietlinden (9/21/2015)
Eric,
I go to the user group meetings the vast majority of the time. Hard to argue with free training where you can ask questions. =)
Maybe my problem is that...
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

September 21, 2015 at 5:53 pm

#1828257
RE: Cannot Drop Table with Non-Printable Character on its name

tanitelle (9/21/2015)
Update:
I've found that when SELECTing the table with the non-printable character, the reason why it returns results from another table, is that during parsing, SQL Server removes 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

September 21, 2015 at 12:45 pm

#1828189
RE: Are the posted questions getting worse?

Alan.B (9/21/2015)
The homework assignment may dictate that the problem be solved with a cursor. Anyone who is good with cursors want to take a look at this?
Anyone good with...
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

September 21, 2015 at 10:09 am

#1828137
RE: Cannot Drop Table with Non-Printable Character on its name

tanitelle (9/21/2015)
Hi, Lowell. Thanks for replying.
Unfortunately, this table cannot be found on sys.tables. Given this, I wondered if it in fact was a view or a synonym, but cannot...
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

September 21, 2015 at 9:32 am

#1828128
RE: Cannot Drop Table with Non-Printable Character on its name

I just tested this out... since you can copy it into NotePad++, try the DDL as:
DROP TABLE [<table name copied from NotePad++>];
The key here is to quote the names with...
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

September 21, 2015 at 9:11 am

#1828117
RE: Dynamic value on Pivot

sushil_dwid (9/21/2015)
Got the solution.. Thanks
Care to share your solution so that others can learn?
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

September 21, 2015 at 8:53 am

#1828109
RE: Dynamic SQL Question

Kristen-173977 (9/20/2015)
GilaMonster (9/19/2015)
protecting against SQL Injection is done, in most cases, by ensuring that it is parameterised, except for the rare scenario where the user input can be white-listed.
We...
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

September 21, 2015 at 8:50 am

#1828106
RE: Why are databases showing up in a newly created instance?

Everything that Gail has said is correct (naturally). If you're seeing the databases from another instance, you are connected to it.
Have you tried running these to see what you are...
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

September 21, 2015 at 8:44 am

#1828103
RE: Painful datetime conversion

Sean Lange (9/17/2015)
I can't change the table at all. It will violate our support contract. Not to mention it would be possible to get trashed with an update at some...
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

September 18, 2015 at 5:51 pm

#1827867
RE: Are the posted questions getting worse?

Luis Cazares (9/18/2015)
Alvin Ramard (9/18/2015)
Jack Corbett (9/18/2015)
Okay, I'm going to give the instructor the benefit of the doubt. Maybe lesson 1 is cursor and lesson 2 is...
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

September 18, 2015 at 3:07 pm

#1827852

Viewing 15 posts - 226 through 240 (of 5,588 total)