Forum Replies Created

Viewing 15 posts - 5,296 through 5,310 (of 13,460 total)

  • RE: Invoice_Dates

    you'll need to show the exact code you are using.

    with that, we can show you how to join against a calendar table to get a range of dates.

    based on my...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 28, 2012 at 7:06 am

    #1506590

  • RE: Invoice_Dates

    you should have continued your question in the original thread.

    this logic :

    SELECT RIGHT ('0000'+Store#,4)

    appends 4 preceeding zeros to the store number, then grabs teh right 4 characters...so store '1'...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 28, 2012 at 6:23 am

    #1506552

  • RE: So Management Studio Just Closed

    not that i'm aware of as far as the log being more dedicated to SSMS.

    did you manually look in the backup folder?

    C:\Users\yourusername\Documents\SQL Server Management Studio\Backup Files\Solution1

    and see if anything was...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 28, 2012 at 6:07 am

    #1506541

  • RE: So Management Studio Just Closed

    Rob to help alleviate some of that headache in the future, grab the SSIS addin here:

    http://www.ssmstoolspack.com/

    one of the things it has is that it automatically keeps a history of every...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 28, 2012 at 5:53 am

    #1506535

  • RE: Query between objects / servers in SMS 2008

    could it be based on an openrowset command??

    --database name required

    SELECT *

    FROM OPENROWSET( 'SQLNCLI',

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 27, 2012 at 2:15 pm

    #1506365

  • RE: Permission to Create, Modify & Delete Views only.

    As far As i know, SQL Server doesn't have the specific granularity to restrict creation to only views;

    giving someone ALTER permissions(like via GRANT ALTER ON schema or the role ddl_admin)...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 27, 2012 at 10:50 am

    #1506269

  • RE: Convert SQL Server query to Oracle query

    I'mn out of practice, but it requires a correlated sub query, and what seems like a wierd format;

    this is untested, but it's kind of like this, which looks weird (from...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 27, 2012 at 9:33 am

    #1506220

  • RE: Invoice

    based on your proposed format, [storenumber][ddmmy], you are assuming a store can only have one invoice a day? what if they want to have two?

    3935 (6/27/2012)

    Hey Guys,

    How can i unique...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 27, 2012 at 7:28 am

    #1506118

  • RE: whether commited transaction will get rollback again

    Reddy Ksr (6/27/2012)

    i think in sql server 2008 we can rollback the committed transaction.

    but in server 2005 we can't.

    can anyone suggest me what will be reason.

    no. a commited transaction is...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 27, 2012 at 6:47 am

    #1506096

  • RE: select nth row of a concatenated query

    also, to get the nth value, i'd add row number to the inner query :

    declare @n int

    SET @n = 4

    SELECT sq.test

    FROM (

    SELECT row_number() over (order by name) As RW,

    ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 27, 2012 at 6:28 am

    #1506083

  • RE: QuickBooks to SQL Server

    i had used the quickbooks driver from http://www.rssbus.com/ado/quickbooks/ so i could connect via a .NET application;

    They had a decent amount of examples, and it was pretty easy to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 27, 2012 at 6:10 am

    #1506072

  • RE: Export pipe delimited data without using dts or ssis

    Jeff Moden (6/26/2012)

    Lowell (6/26/2012)

    i believe your options are to use bcp, CLR or powershell

    bcp + TSQL isgoing to require opening up xp_cmdShell.

    BWAA-HAAA!!!! I use xp_CmdShell to run PowerShell...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 26, 2012 at 4:15 pm

    #1505906

  • RE: Export pipe delimited data without using dts or ssis

    i believe your options are to use bcp, CLR or powershell

    bcp + TSQL isgoing to require opening up xp_cmdShell.

    EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT object_name(object_id) As TbLName,name as ColName FROM SandBox.sys.columns...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 26, 2012 at 2:23 pm

    #1505842

  • RE: How to embed image with text in SSRS

    did i read your requirement wrong?

    i thought you wanted to build an image on the fly based ond ata in your dataset, was i wrong?

    that was the development path i...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 26, 2012 at 2:10 pm

    #1505832

  • RE: Production issue with varchar(max)

    ramadesai108 (6/26/2012)

    The closing quote is correct. After the long string, I have a year, '2012' as a variable. If I run the proc as follows then there are no...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 26, 2012 at 12:31 pm

    #1505776

Viewing 15 posts - 5,296 through 5,310 (of 13,460 total)