Viewing 15 posts - 6,616 through 6,630 (of 15,381 total)
isuckatsql (10/4/2013)
I have the following sp which is being slowed down by the following count statement:-(select COUNT(*) from EMPLOYMENT_OPPORTUNITIES_CTE) as TotalCount FROM (
No offense but you have a lot...
October 4, 2013 at 12:43 pm
I will go one step further and think outside the checkbox. 😉
You seem to have 3 checkboxes that you want to allow only one of them to be selected...
October 4, 2013 at 11:53 am
RedBirdOBX (10/4/2013)
The only thing I can come up with...
October 4, 2013 at 11:49 am
david.kotchie (10/4/2013)
Thanks for this, but I don't use an SP - it is a simple select statement.
I am a little confused here. You say you don't have this in a...
October 4, 2013 at 11:47 am
RedBirdOBX (10/4/2013)
I have a table containing people and except for...
October 4, 2013 at 11:40 am
adams.squared (10/4/2013)
Worked like a charm
Sweet glad to hear it.
October 4, 2013 at 11:32 am
Erin Ramsay (10/4/2013)
More ideas.
Normalize your data and then you aren't fighting this. Honestly the biggest challenge you are facing is the lack of normalization.
That being said you have a real...
October 4, 2013 at 11:05 am
UDBA (10/4/2013)
October 4, 2013 at 10:54 am
adams.squared (10/4/2013)
I have over 30,000 customer IDs. Reading the split, it looks like it can handle 8,000 characters.
Maybe you need a couple of queries then. If they want all...
October 4, 2013 at 10:49 am
adams.squared (10/4/2013)
October 4, 2013 at 8:12 am
Junglee_George (10/4/2013)
I have a requirement where I need to show a column name in a SSRS report in the following format:
List of <Hazards.hazardCode> separated by ", "
<MaterialsItems.otherHazards>
Here, Hazards and MaterialsItems...
October 4, 2013 at 7:25 am
naxysch (10/4/2013)
I have a table of like more than 50 columns, and my problem here is that I want ALL but 2 or 3 column names in my SELECT clause!...
October 4, 2013 at 7:22 am
SrcName (10/3/2013)
if you define constraint then you don't have situation for update,because there will be no rows with impaired restriction, unless you disable constraint.
???
I am curious how you would...
October 3, 2013 at 2:01 pm
pjcafonso (10/3/2013)
If Col2 = 1 then Col3 can't be changed, is not allowed update there value.
About DDL I mean Data Definition...
October 3, 2013 at 1:33 pm
dwain.c (10/2/2013)
ken_gardiner (10/2/2013)
October 3, 2013 at 12:13 pm
Viewing 15 posts - 6,616 through 6,630 (of 15,381 total)