Forum Replies Created

Viewing 15 posts - 3,976 through 3,990 (of 13,460 total)

  • RE: Instead of Insert and Insert Trigger

    In general, I think the preference is to avoid triggers when possible.

    after that, it's not a preference, but rather which method, a standard insert trigger vs an instead of 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!

    February 19, 2013 at 1:05 pm

    #1589347

  • RE: Group By ..Values into a single row

    ok not as hard as i thought: here you go:

    SELECT StateName,stuff(( SELECT ',' + CONVERT(varchar,RW) + '.' + CityName

    ...

    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!

    February 19, 2013 at 11:33 am

    #1589322

  • RE: Group By ..Values into a single row

    getting the cities as a list wasn't hard, but i'm having trouble numbering them inline; my row_number verisons not quite there yet, but here's the start of it:

    SELECT StateName,stuff(( ...

    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!

    February 19, 2013 at 11:31 am

    #1589320

  • RE: Revoking public Role Permissions not working

    i guess the question is how are you testing the public permissions then?

    did you create a new database user , unconnected form any login like this?

    are you using execute as?...

    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!

    February 19, 2013 at 11:05 am

    #1589311

  • RE: finding out users or login who has committed wrong data

    MyDoggieJessie (2/19/2013)

    I don't believe this is possible unless you already have Change Data Capture running

    There is nice app from ApexSQL which can be used as a trial and literally and...

    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!

    February 19, 2013 at 10:44 am

    #1589301

  • RE: Schedule report After 110 Days of the Past quarter

    I'm awful sure there is a solution to that; I know i've seen lots of SSRS topics like "don't send if no data is found", kind of threads.

    this was just...

    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!

    February 19, 2013 at 10:16 am

    #1589291

  • RE: Schedule report After 110 Days of the Past quarter

    not a reporting services guru, but for regular scheduled jobs, i can create a job which does something, like send an email or update or whatever, that runs 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!

    February 19, 2013 at 9:47 am

    #1589273

  • RE: Slow Update Processing - Badly Written Code ?

    homebrew i think this is equivilent to your first update query, but should theoretically perform better.

    compare the SELECT to teh UPDATE , and tell me if it looks like 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!

    February 19, 2013 at 8:59 am

    #1589246

  • RE: Get DDL for any SQL 2005 table

    nikus thank you for the feedback! i really appreciate 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!

    February 19, 2013 at 8:16 am

    #1589223

  • RE: datatype for such a long integer

    awesome solution Cadavre!

    only thing i would do is clean up the presentation with REPLICATE to get the zeros, and maybe just a simple not like '%[^0-9]%' ; what do you...

    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!

    February 19, 2013 at 6:18 am

    #1589172

  • RE: xp_cmdshell access denied to desktop file when logged as administrator - why ?

    ohpenot (2/19/2013)

    Hi Lowel,

    Have the same problem "access denied" when trying to exec "xp_cmd". Except that i am on windows seven. The company isntalled sql express on my machine to start...

    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!

    February 19, 2013 at 5:15 am

    #1589147

  • RE: Clustered Key. (Making it unique).

    Bhuvnesh (2/18/2013)

    GilaMonster (2/15/2013)

    identity column does not guarantee uniqueness.

    is it so ? but it always generate new value incremented to previous one

    True but its only half of the puzzle,...

    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!

    February 18, 2013 at 5:16 am

    #1588788

  • RE: Does .Net framework 2.0 is compulsory for sql server express 2005

    winmansoft (2/16/2013)

    Does .net 2.0 is required only for installation of sql server 2005 express or does it used by sql server for it's working?

    .net 2.0 is Required for both installation...

    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!

    February 16, 2013 at 4:32 am

    #1588596

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (2/15/2013)

    Why do we still use ' as a text indicator in databases? Why haven't we (meaning people who design systems) created a unique symbol that we can...

    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!

    February 15, 2013 at 1:51 pm

    #1588487

  • RE: Unseen characters

    prathibha_aviator (2/15/2013)

    Lowell,

    Thankyou for ur response.. It worked so well.. I just couldnt believe that my problem resolves in no tym... 🙂 Would you also help me Now if i want...

    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!

    February 15, 2013 at 1:38 pm

    #1588480

Viewing 15 posts - 3,976 through 3,990 (of 13,460 total)