ramana3327 (6/8/2014)

---

Hi,

I am working in a particular application. My work is to tune the sp that are using by that particular application. First, I want to list out all Sprocs...

kamamusic (6/8/2014)

---

Dear All,

I would ask for your help in order to be sure that my reasoning is correct. I am migrating a server structure from SQL 2008 to 2012 and...

tshad (6/7/2014)

---

Is there an easy way to send back to my C# program the pascal case of a field type? If you get the parameters or columns for a...

ykonline (6/7/2014)

---

Hi,

I have a requirement to import excel sheet which we receive daily, sometimes it may contain extra columns that needs to be imported to staging table as it is.

Please...

Would you be so kind to provide DDL (create table) scripts and some sample data? Then we don't have to do any guesswork:-D

😎

Somewhat belts and braces method

😎

USE tempdb;

GO

USE tempdb;

GO

DECLARE @num AS...

clayman (6/8/2014)

---

INSERT INTO @Range(LowerBound, UpperBound)

VALUES(1, 9),

(10, 24),

(25, 49),

...

ayazniazi (6/8/2014)

---

I have a for each container that is enumerating inside excel files. I have a file system task inside the container. The file system has to copy files from...

ayazniazi (6/8/2014)

---

I have a package and within that package I am executing another package using the Execute Package Task. I get the following error The LoadFromSQLServer method has encountered OLE...

Hi, and welcome to the forum. We need some help from you in order to assist you. Have a look at this article on the subject; How to post data/code...

Quick thought, is it an option to upgrade the VB6 application? VB 2008 has a conversion option, think that's the last version where it's included.

The problem sounds like the application...

Matthew.Procter (6/8/2014)

---

Hi all,

Got an issue that I can't work out. I have 2 tables, with "clientcode" field that in both is a varchar(50)

If I query the tables individually, I get...

Phil Parkin (6/8/2014)

---

+1

😎

For fun, a quick demonstration

😎

/* 250 Gb */

DECLARE @MY_NumberOfBytes NUMERIC(12,0) = 268435456000;

/* bytes */

SELECT

'Bytes' ...

Further Lynn's demonstration, here are few different ways the SQL Server handles NULL test (using Lynn's data).

😎

select * from

(

SELECT Column1, coalesce(Column2,0.0) as Column2

FROM NULL_TEST

) as x where x.Column2 <> 0

/*

[Expr1003]...