Forum Replies Created

Viewing 15 posts - 2,101 through 2,115 (of 13,460 total)

  • RE: Is it a good idea to use a UDDT + Rules for this?

    the decision on needing some format was made above your head, but the implementation is where you have some flexibility.

    you can still use a foreign key to a parent table,...

    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!

    January 15, 2015 at 12:14 pm

    #1770536

  • RE: BCP hangs in T-SQL not at DOS prompt

    i'm thinking the issue here is what account is running SQL when you drop to xp_cmdShell; you are choosing trusted connection,w hcih means if the user running the services 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!

    January 13, 2015 at 11:39 am

    #1769907

  • RE: Read dynamic XML

    are you having troulbe using XQuery?

    here's an example based on your data, with that you can format it into columns or whatever.

    /*--Results

    SSN ...

    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!

    January 13, 2015 at 7:41 am

    #1769818

  • RE: query/script/stored procedure which will return a single table with three columns

    great glad i could point you in the right direction then.

    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!

    January 13, 2015 at 6:52 am

    #1769793

  • RE: query/script/stored procedure which will return a single table with three columns

    what's the query you would use to get tat same data from a single database? if you have that, you can automate it across all databases.

    you just need to wrap...

    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!

    January 13, 2015 at 5:35 am

    #1769772

  • RE: Query to show the names of the ServiceTypes that have more customers via Web form than Telephone

    /*--Results

    ServiceTypeWebQtyTelQty

    Cleaning600200

    Support900400

    */

    ;WITH MyCTE([ServiceType],[CommunicationType],[CustomerQty])

    AS

    (

    SELECT 'ICT','Telephone',500 UNION ALL

    SELECT 'Cleaning','Web form',600 UNION ALL

    SELECT 'Support','On site',35 UNION ALL

    SELECT 'ICT','Web form',300 UNION ALL

    SELECT 'Cleaning','On site',40 UNION ALL

    SELECT 'Support','Telephone',400 UNION ALL

    SELECT 'ICT','On site','100' UNION ALL

    SELECT 'Cleaning','Telephone',200 UNION...

    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!

    January 12, 2015 at 1:46 pm

    #1769636

  • RE: Microsoft.ACEOLEDB.12.0 is not registered. Class not registered

    glad i could help!

    post your new error if you think a little peer review might help you get past that one as well..

    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!

    January 12, 2015 at 1:12 pm

    #1769630

  • RE: Microsoft.ACEOLEDB.12.0 is not registered. Class not registered

    seen that one before! there's a secret switch in there that lets you install; i've had to do the opposite...install the 64 bit verison wher ethe 32 bit office 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!

    January 12, 2015 at 12:40 pm

    #1769619

  • RE: dynamic query

    i was unclear on the requirements, myself....i thought this was a visualization of a hierarchy, so he'd want whale--shark--pirana--octopus

    his sample table is a varchar(1), also, which would probably be an...

    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!

    January 12, 2015 at 11:40 am

    #1769595

  • RE: Capture database name or database Id in dbcc show_statisics result

    modify your table to have the database name in it.

    explicitly name your columns in the insert statement.

    since this is in a cursor/loop, just udate the database name where it 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!

    January 12, 2015 at 11:22 am

    #1769590

  • RE: char(n) v varchar(n) - data type length question

    yeah nvarchar uses twice the memory to store the data, that can be confusing.

    that's because nvarchar can store character sets that varchar can't.

    select N'??? / ??? huìyìzì','??? / ??? huìyìzì'

    /*

    (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!

    January 12, 2015 at 10:18 am

    #1769570

  • RE: char(n) v varchar(n) - data type length question

    data length returns the length of the string, not the memory required to store the string itself.

    so the data_length really is five, but yes, sql uses at least seven...

    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!

    January 12, 2015 at 10:01 am

    #1769561

  • RE: SAN Response Times

    don't be ridiculous. you can run it on production. it's doing what your server is already doing; in this case it creates a four gig file and tests how fast...

    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!

    January 11, 2015 at 7:28 pm

    #1769370

  • RE: Check if database exist

    dynamic sql to create the database? that won't fix any warnign where you have a USE [NewDB] that doesn't exist at parse time, i think:

    if NOT EXISTS(SELECT * 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!

    January 9, 2015 at 1:13 pm

    #1769188

  • RE: sp_who2 shows wrong value of hostname and login for a spid

    I know you explicitly said same server, but that's too weird.

    so theres no chance you are in a multi server environment, and the window you look at is test/development, but...

    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!

    January 9, 2015 at 1:08 pm

    #1769186

Viewing 15 posts - 2,101 through 2,115 (of 13,460 total)