Good stuff and you are very welcome

😎

sp_who2

sealed

Jeff Moden (8/6/2015)

---

stevenb 14609 (8/6/2015)

---

I use xp_CmdShell for 2 different things.

One is to export csv reports for end users.

The other one is to export and then FTP files...

Tac11 (8/6/2015)

---

When I run below query I get 3 columns, but when I try to add table name

ind.object_name (object_id) it's giving me an error "Ambiguous column name 'object_id"

How do...

Yogeshwar Phull (8/6/2015)

---

Thanks for the replies.

Well, I am trying to fix something that was already in place for sometime and I have no clue on how the front end works....

I agree with Jeff on this one, nothing is going to be faster than bcp, are all lines in the incoming file the same format/layout?

😎

Now just for fun, here is...

ravi@sql (8/6/2015)

---

HI Champs,

Am converting varchar field to float and summing using group by and next inserting to varchar field(table).

while inserting float value it is converting to exponential ex:1.04177e+006

but if i...

Eddie Wuerch (8/5/2015)

---

A quick check of the function's source :

USE master;

GO

EXEC sp_helptext 'fn_varbintohexstr';

GO

Reveals the source code:

create function sys.fn_varbintohexstr

(

@pbinin varbinary(max)

)

returns nvarchar(max)

as

begin

return...

Manic Star (8/5/2015)

---

I know this function is not supported by Microsoft, but some of the developers insisted on using it anyway on two of our 2k8 r2 databases.

Is there...

No need to handle the numbers as a string, just select from the table where it is less than the next value up.

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo..#temp') IS NOT NULL...

alark (8/5/2015)

---

Hi,

We have SSIS packages deployed and scheduled on SQL_Server_A. The packages have to access databases on SQL_Server_B, which is behind a firewall.

Question: would opening only SQL port...

Further on Kevin's and Luis's answers, optimizing this code to half the execution time should not be too hare, neither getting under one second but this takes some time, do...

Sean Lange (8/5/2015)

---

GAH!!! Sometimes I hate having to work with so many different versions of sql all the time. I have been beating my head against the wall trying to...

Potty