Viewing 15 posts - 16 through 30 (of 760 total)
Cadavre (6/29/2013)
kapil_kk (6/29/2013)
that was trns1 only not trns2...
I tried it but not it is not possible with min...
July 1, 2013 at 3:21 am
The function in the view is a table valued function. This code is actually very old. It runs on one of our SQL Server 2000 servers and yes the Distinct...
June 28, 2013 at 12:18 am
Good question on how parsing works.....very important to know the internals well.
June 23, 2013 at 10:15 pm
A very good question and well explained as well. 🙂
June 19, 2013 at 11:49 pm
nitha jen (6/12/2013)
CREATE proc [dbo].[student_marks]
@roll_no varchar(20)
AS
BEGIN
CREATE TABLE #temp
(
semester INT,
marks INT
)
INSERT INTO #temp
(
semester,
marks
)
SELECT
semester,
(...
June 12, 2013 at 10:58 pm
Nevermind, I was thinking too much. It was simple, you just have to export the data to a .csv file using DTS and then edit the data for dates and...
June 6, 2013 at 12:20 am
I don't agree....I thought the options weren't precise enough....I couldn't work it out in my head....so I executed it to find out that my answers don't match the condition in...
May 31, 2013 at 6:09 am
Hi,
Hope this works for you:
---Creating Table
Create table Ex
(
Sales_2012Float,
Plann Float,
fiscal_week_2013 Date,
Sales_2013 Float,
LY Float,
PN Float
)
--Inserting Data
Insert Into Ex
Select 232.2935700,286.8642,'2013-01-05',263.1448400,0.132811553931518638,-0.0826852665251378...
May 30, 2013 at 7:20 am
dwain.c (5/19/2013)
The anti-RBAR alliance will forever bless you if you do.
Amen!!!! :-D:-D
May 20, 2013 at 12:40 am
Slawomir Swietoniowski (5/12/2013)
Msg 1038, Level...
May 13, 2013 at 3:20 am
kapil_kk (5/2/2013)
Easy one to the end of week 😛
+1. But good for testing basics...even if its not a real scenario.
May 2, 2013 at 11:24 pm
A very easy one Danny....but nothing better than going back to basics 🙂
Edit: Sorry for the double post....the browser hung up on me. :hehe:
May 1, 2013 at 10:31 pm
A very easy on Danny....but nothing better than going back to basics 🙂
May 1, 2013 at 10:31 pm
Viewing 15 posts - 16 through 30 (of 760 total)