Regd Query

Question

Regd Query

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110640 More actions · Answer 1

By the way, the execution time on that query, including creating the table variable with the tally numbers, was less than 1 second.

Steve

(aka smunson)

:):):)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Jeffrey Williams SSC Guru Points: 90303 More actions · Answer 2

I just copied the code you posted and ran it and got the expected results. Are you getting any errors?

Can you run the following and verify the results:

SELECT COUNT(*) FROM dbo.Tally;

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Chinna SSCertifiable Points: 5408 More actions · Answer 3

I HAVENT GOT ANY ERROR BUT IAM NOT GETTING ANY OUTPUT IT JUST SHOWS NULL NOTHING AND WHEN I RUN COUNT(*) I GOT AS 0

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

Chinna SSCertifiable Points: 5408 More actions · Answer 4

STEVE ---IS N HERE THE CHARACTER COUNT IN THAT STRING--

SELECT SUBSTRING(@Parameter,N+1,CHARINDEX(',',@Parameter,N+1)-N-1)

FROM @TALLY

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

sgmunson SSC Guru Points: 110640 More actions · Answer 5

Sounds like you haven't populated your tally table. Try my code using the table variable and see if that helps you. You can adapt it to populate dbo.Tally.

Steve

(aka smunson)

:):):)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Chinna SSCertifiable Points: 5408 More actions · Answer 6

YES YOU WERE RIGHT I HAVENT POPULATED THE TABLE...GOT IT THKZ STEVE...

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman