Forum Replies Created

Viewing 15 posts - 7,201 through 7,215 (of 13,460 total)

  • RE: Urgent Function and Dynamics SQL

    i know logically, it makes sense to get the id's you are looking for in one table, adn then do a seperate step;

    but from a good TSQL point of view,...

    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!

    July 7, 2011 at 6:10 am

    #1349609

  • RE: Is there a limit on the number of values that can be used in an IN clause?

    nope no practical limit; that table could be billions of rows in the subquery;

    the only practical limit might be speed; proper indexing might need to be looked at so...

    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!

    July 7, 2011 at 6:02 am

    #1349598

  • RE: pipe Delimited

    yet another way is since you already did the export, using a decent text editor like EditPlus you can use a regular expression to find \n (CrLf) and replace it...

    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!

    July 6, 2011 at 11:46 am

    #1349182

  • RE: Delete After Trigger

    i stand corrected; unless the call was wrapped in a transaction, the code does execute, the row gets deleted, and the archive table does get the deleted row even with...

    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!

    July 6, 2011 at 11:14 am

    #1349156

  • RE: Delete After Trigger

    toddasd (7/6/2011)

    The RAISERROR doesn't rollback the transaction, you would need an explicit ROLLBACK TRANSACTION after that statement.

    Wendel, your trigger is fine, but I'm thinking other triggers may be interferring. Disable...

    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!

    July 6, 2011 at 11:00 am

    #1349142

  • RE: SSIS bit Fields? True/False vs 0/1

    Learning a lot today guys, thanks for the input.

    I did as Phil suggested,and changed my datasource to use an OLEDB Source, made the SQL do the conversions, and it exports...

    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!

    July 6, 2011 at 10:17 am

    #1349112

  • RE: Brain racking for fun (Can you track/capture a select from a specific Login)

    GilaMonster (7/6/2011)

    You don't. You tell whoever wrote the app that they must call stored procs not run adhoc queries.

    Frankly the idea of modifying the returned data is terrifying. If 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!

    July 6, 2011 at 9:17 am

    #1349066

  • RE: Delete After Trigger

    change your raiserror to a print statement...wouldn't raising an error of 16 or above inside the trigger rollback the trigger?

    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!

    July 6, 2011 at 8:40 am

    #1349030

  • RE: Brain racking for fun (Can you track/capture a select from a specific Login)

    i'm with Gail; all you can do is trace it...so i don't think so; for example the DMV's that have the execution plans for a given statement would occur after...

    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!

    July 6, 2011 at 8:38 am

    #1349029

  • RE: Recursion Query to get Children and children of children using With

    here's a recursive CTE example i keep in my snippets; if you can provide the CREATE TABLE/INSERT INTO statemetns like this example, we could help you with yours, but this...

    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!

    July 6, 2011 at 8:30 am

    #1349021

  • RE: Must declare scalar variable.

    run as a batch, i saw what you pasted was missing an open parenthesis, but otherwise just fine.

    i suspect it's a highlight-and-F5 issue.

    are you highlighting, say each section one part...

    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!

    July 6, 2011 at 7:42 am

    #1348957

  • RE: Adding Quotes around Every Column

    Vertigo44 (7/6/2011)

    Sorry I should have been more clear.

    I have already imported a cobal database into a sql database using an ODBC connection.

    Now that I have finished mapping the fields...

    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!

    July 6, 2011 at 5:52 am

    #1348853

  • RE: Datacenter Edition?

    this has got some nice comparison tools on the page..i selected Datacenter and Enterprise for example, and then i can scroll through so many comparision options ....

    http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

    at a glance, it...

    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!

    July 5, 2011 at 2:19 pm

    #1348572

  • RE: t-sql to add a user to ALL DB's on the server....

    i think all you need is EXEC in from of the proc: multi line statements require EXECUTE procname, only when a command is standalone can you just put the name...

    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!

    July 5, 2011 at 1:05 pm

    #1348530

  • RE: Oddball Configuration Question

    depending on the application, if it was doing anything with importing from access,excel or raw text files using the JET 4.0 driver , jumping to 64 bit becomes a big...

    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!

    July 5, 2011 at 11:57 am

    #1348504

Viewing 15 posts - 7,201 through 7,215 (of 13,460 total)