Sean Lange

Forum Replies Created

Viewing 15 posts - 10,996 through 11,010 (of 15,381 total)

RE: varbinary(max)

Rainmaker097 (8/20/2012)
Hi,
if it is only going to display 8000 chars, what is the point of using a column that can have more than 8000 chars?
Am I "select"ing it wrong?
RM
The data...

August 20, 2012 at 1:43 pm

#1527837
RE: Create Trigger within StoredProc

Luis Cazares (8/17/2012)
No one said they were working on a production database.
I believe that most problems like this should be solved with other administration options and not triggers. I wouldn't...

August 17, 2012 at 2:16 pm

#1527249
RE: Create Trigger within StoredProc

Luis Cazares (8/17/2012)
Sean Lange (8/17/2012)
Why do you have users that are not competent with sql that have SSMS installed on their desktops? If they can't be trusted with SSMS get...

August 17, 2012 at 1:14 pm

#1527231
RE: Create Trigger within StoredProc

DBA_SQL (8/17/2012)
Well I have a Scenario: We have users who requires db_datareader and db_datawriter permissions to run there front end applications. We are using windows authentication as access permissions....

August 17, 2012 at 12:46 pm

#1527222
RE: Does Not Allow Multiple Updates Using A Sub Query

Lynn Pettis (8/17/2012)
Stylez (8/17/2012)
Hi Lynn. Yes, I was trying to Set All The Dates To January 1 (For Data Scrubbing Purposes). i am also thinking if a trigger is causing...

August 17, 2012 at 9:45 am

#1527149
RE: Concatenate Data

Can you post ddl and sample along with desired output? Take a look at the first link in my signature for best practices when posting questions.

August 17, 2012 at 9:40 am

#1527144
RE: adding specific column data w.rto date, where TOTAL_ELECTRONIC_VALUE which s already added

anushamsbi (8/17/2012)
Hi,
It is not working.. can u pls eloborate that one..
Can you elaborate on "It is not working"? What does that mean? Did you get an error message? Did it...

August 17, 2012 at 7:18 am

#1527073
RE: Are the posted questions getting worse?

dwain.c (8/17/2012)
ChrisM@Work (8/17/2012)
dwain.c (8/16/2012)
Lynn Pettis (8/16/2012)
Here is one for the do not hire list.
Or it could be the needs much training list.
The quality of the hires will be roughly proportional...

August 17, 2012 at 7:04 am

#1527062
RE: Get column names in first row of result set

Lynn Pettis (8/16/2012)
Sean Lange (8/16/2012)
I was just about to suggest using SSIS instead but it looks like Lynn beat me to it. 😀
Something about using the right tool for the...

August 16, 2012 at 12:57 pm

#1526788
RE: Get column names in first row of result set

I was just about to suggest using SSIS instead but it looks like Lynn beat me to it. 😀

August 16, 2012 at 12:53 pm

#1526785
RE: Get column names in first row of result set

Ken Davis (8/16/2012)
Sure. A client wants it that way. They want a CSV file with the contents of a view and they say they need the first row...

August 16, 2012 at 12:52 pm

#1526784
RE: Get column names in first row of result set

Quite an odd requirement but it is going to take some work on your end.
Something like this should work.
select 'Col_1' as Col_1, 'Col_2' as Col_2, 'Col_3' as Col_3, 0 as...

August 16, 2012 at 12:35 pm

#1526774
RE: showing non existing records from multiple dataser

Pretty sparse on details but I think you want to use a left join instead of a union.

August 16, 2012 at 8:38 am

#1526630
RE: Query runs slow

So if you totally remove the date check then it runs fast again? That sounds like indexing to me.

August 16, 2012 at 8:19 am

#1526613
RE: Query runs slow

ChrisM@Work (8/16/2012)
pwalter83 (8/16/2012)
Hi,
The query I am working on runs very slow due to a piece of code -
CREATE_DT > = DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) -1
Could someone please suggest...

August 16, 2012 at 7:50 am

#1526588

Viewing 15 posts - 10,996 through 11,010 (of 15,381 total)