Easy One. Happy Independence Day Americans!!

Cadavre (6/29/2013)

---

kapil_kk (6/29/2013)

---

Srry that was typo misktake in my question n i Have corrected that...

that was trns1 only not trns2...

I tried it but not it is not possible with min...

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...

Good question on how parsing works.....very important to know the internals well.

A very good question and well explained as well. 🙂

nitha jen (6/12/2013)

---

can anyone help me? i am new to db....

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,

(...

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...

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...

Hi,

Hope this works for you:

---Creating Table

Create table Ex

(

Sales_2012 Float,

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...

Very Good One.

Amen!!!! :-D:-D

Slawomir Swietoniowski (5/12/2013)

---

This question is stated wrong, cont(...) does not have any alias for the name, so, while you will try to execute this code, you will get:

Msg 1038, Level...

+1. But good for testing basics...even if its not a real scenario.

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:

A very easy on Danny....but nothing better than going back to basics 🙂