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

Luis Cazares (8/5/2015)

---

Eirikur Eiriksson (8/5/2015)

---

SQLRNNR (8/5/2015)

---

Sean Lange (8/5/2015)

---

Or better...

SQLRNNR (8/5/2015)

---

Sean Lange (8/5/2015)

---

Or better yet - don't forget...

Ed Wagner (8/5/2015)

---

Jack Corbett (8/5/2015)

---

I couldn't answer all the questions, but I don't expect to be able to answer every question in an interview. I would think...

Luis Cazares (8/5/2015)

---

Eirikur Eiriksson (8/5/2015)

---

Brandie Tarvin (8/5/2015)

---

I am shattered, y'all. Just shattered.

Romance is officially dead.

I'll be in the back of the Tent in the Desert, crying my eyes out for...

DBAMike (8/5/2015)

---

Has anyone seen this error returned from an application server whilst running a stored procedure against a SQL2012 database?

I have a simple SP that returns 2 columns with 4...

Quick example, should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = N'<worksheet name="All itemss Totals">

<layout-options>

<title>

<formatted-text>

<run fontalignment="2" fontcolor="#ffffff">finance</run>

</formatted-text>

</title>

</layout-options>

<repository-location derived-from="www.xyz.com/test" id="AllitemssTotals" path="/workbooks/SubitemsActivity" revision="" />

<table>

<view>

<datasources>

<datasource caption="Allitemss" name="sqlserver.42074.554624143515"...

c'est la vie

😎