Viewing 15 posts - 3,496 through 3,510 (of 8,731 total)
Eirikur Eiriksson (1/22/2016)
Luis and Jack, you are both right in the terms of suppressing the problem, preventing it is in my mind a better approach.😎
Fixing the whole code would be...
January 22, 2016 at 9:11 am
vinod.joshi040 (1/22/2016)
I'm facing problem while using cross tab, what my problem is:
sample data:
DCI_SNODCI_COMPOUNDDCI_BLOCKDCI_PARAMETERDCI_DESCRIPTIONDCI_UNIT
1 U1001AI1 AI010301PNT...
January 22, 2016 at 9:06 am
whereisSQL? (1/22/2016)
crookj (1/22/2016)
Ed Wagner (1/22/2016)
VillainJoker
Laugh
last
January 22, 2016 at 8:33 am
You're using sysname as datatype for your columns. Sysname is by default NOT NULL.
You're effectively not inserting any null values explicitly, but you were missing the column in your insert...
January 22, 2016 at 8:00 am
Now, either you build a query with all possible columns or you build a dynamic query to get the columns available.
I'll suggest that you go for the first option as...
January 21, 2016 at 1:08 pm
djj (1/21/2016)
Ed Wagner (1/21/2016)
crookj (1/21/2016)
Igor Micev (1/21/2016)
Ed Wagner (1/21/2016)
DonlSimpson (1/21/2016)
Igor Micev (1/21/2016)
Grumpy DBA (1/21/2016)
Ed Wagner (1/21/2016)
djj (1/21/2016)
BL0B_EATER (1/21/2016)
Stuart Davies (1/21/2016)
Ed Wagner (1/20/2016)
Ray K (1/20/2016)
djj (1/20/2016)
RoastedChicken
Ribs
Spare
Tyre
Tired
Sleep
Insomnia
AlwaysOn
Availability
Phone
Cell
Red (blood)
White
Blue
France
January 21, 2016 at 1:05 pm
What version of SSMS are you working with? I don't have that problem with version 11.0.2100.60 which is basically a version of 2012.
January 21, 2016 at 11:43 am
MMartin1 (1/21/2016)
Chris Wooding (1/21/2016)
To answer the original question; thishttp://www.sqlservercentral.com/Forums/Topic1752249-1292-1.aspx
is recursion.
I would also call that an infinite loop. A Recursive function should have a cut off point. 😛
There is one,...
January 21, 2016 at 11:37 am
Any questions, comments or improvements?
WITH CTE AS(
SELECT m.date,
CASE WHEN EXISTS( SELECT * FROM #mytable c
...
January 21, 2016 at 11:29 am
It seems that you have an EAV design which can be a problem with queries and you might want to change it to a properly normalized model.
To query this designs,...
January 21, 2016 at 10:17 am
From the other thread:
Luis Cazares (1/21/2016)
You just need to use 2 joins in your query.There's an example at the bottom of this page: http://www.sql-join.com/
January 21, 2016 at 9:48 am
Are you looking for something like this?
SELECT m.date,
CASE WHEN m.date < '20000530' AND m.industry = 'Corporate'
THEN...
January 21, 2016 at 9:26 am
Do you want each character? Or the rows that contain the foreign characters?
January 21, 2016 at 8:45 am
Duplicate thread. Please reply in here: http://www.sqlservercentral.com/Forums/Topic1754550-392-1.aspx
January 21, 2016 at 8:31 am
You just need to use 2 joins in your query.
There's an example at the bottom of this page: http://www.sql-join.com/
January 21, 2016 at 8:30 am
Viewing 15 posts - 3,496 through 3,510 (of 8,731 total)