Viewing 15 posts - 8,056 through 8,070 (of 8,753 total)
ramana3327 (6/8/2014)
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...
June 9, 2014 at 1:54 am
kamamusic (6/8/2014)
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...
June 9, 2014 at 1:46 am
tshad (6/7/2014)
June 9, 2014 at 1:42 am
ykonline (6/7/2014)
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...
June 9, 2014 at 1:39 am
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
😎
June 9, 2014 at 1:34 am
clayman (6/9/2014)
Thank you for the heads up, I'll fix that! Any suggestions regarding the gap for the 25.00 - 49.00 range?
Somewhat belts and braces method
😎
USE tempdb;
GO
USE tempdb;
GO
DECLARE @num AS...
June 9, 2014 at 1:05 am
clayman (6/8/2014)
INSERT INTO @Range(LowerBound, UpperBound)VALUES(1, 9),
(10, 24),
(25, 49),
...
June 8, 2014 at 11:38 pm
ayazniazi (6/8/2014)
June 8, 2014 at 10:58 pm
ayazniazi (6/8/2014)
June 8, 2014 at 10:38 pm
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...
June 8, 2014 at 10:29 pm
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...
June 8, 2014 at 10:26 pm
Matthew.Procter (6/8/2014)
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...
June 8, 2014 at 10:01 pm
Phil Parkin (6/8/2014)
The obvious (at least, to me) solution is to not use an identity column as the target.
+1
😎
June 8, 2014 at 3:36 am
For fun, a quick demonstration
😎
/* 250 Gb */
DECLARE @MY_NumberOfBytes NUMERIC(12,0) = 268435456000;
/* bytes */
SELECT
'Bytes' ...
June 8, 2014 at 3:29 am
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]...
June 7, 2014 at 2:35 pm
Viewing 15 posts - 8,056 through 8,070 (of 8,753 total)