LutzM

Forum Replies Created

Viewing 15 posts - 4,876 through 4,890 (of 5,502 total)

RE: Use of cursors with XML data in sql 2000

Aur_Ek_SQL (10/9/2009)
Above question if resolved. ...
Would you mind sharing your solution so others can benefit?

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 9, 2009 at 10:02 am

#1064212
RE: Shredding XML nodes for the node names

Would something like the following help?
DECLARE @xml xml
SET @xml='<root>
<column_name>
<node_a>value1</node_a>
<node_b>value2</node_b>
</column_name>
</root>'
SELECT
T.n.value('localname[1]', 'varchar(100)') AS Localname,
...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 8, 2009 at 2:20 pm

#1063726
RE: splitting the values of column

You might want to search for "split string function" on this site.

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 8, 2009 at 2:09 pm

#1063714
RE: Running the View is Timing out but works in select HELP!

ritesh.kansara (10/8/2009)
to create the view, I've gone into the management studio and selected view - new view and copy and pasted the above SQL statement into it. I've saved...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 8, 2009 at 1:16 pm

#1063685
RE: Are the posted questions getting worse?

Lynn Pettis (10/6/2009)
I'm taking a 2 week vacation starting next week, and I may or may not be around. We are driving to Ft Jackson, SC to see my...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 5:51 pm

#1063165
RE: Unable convert nvarchar to int

Like I stated above:
If you insist on using your data structure you might want to search for "split string function" on this site. It'll help you for now but it's...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 5:09 pm

#1063155
RE: Allowing users to create tables though the front end.

Ruaghain (10/7/2009)
As it stands it's envisaged that Admin users will be fairly knowledgeable with regards to database design (indeed, it's something that we demand), and obviously we will provide some...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 4:59 pm

#1063154
RE: Unable convert nvarchar to int

Easiest thing would be to change your data to be normalized:
Instead of
tbl_house_fails
---------------
4 - 1,2,3 - 07/10/2009
insert the values as separate rows. It's a lot easier to work with...
4 -...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 4:28 pm

#1063144
RE: New to SSIS- and need help in Audit processing

Duplicate post.
Please continue discussion here .

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 4:20 pm

#1063140
RE: Allowing users to create tables though the front end.

Allowing users to create their own tables is almost like open Pandoras box...
Once they can create a (simple) table the next requests most probably will be:
- design complex tables using...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 4:14 pm

#1063137
RE: date in database row is YYYY/MM/DD but in asp RETURNS DD/MM/YYYY

You could try to force the output from SQL Server to U.S. standard format using CONVERT(CHAR(10),YourDateValue,101).
Edit: ... but this won't be a date format anymore. But it's possible that your...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 3:57 pm

#1063130
RE: Cursorfetch - number of variables declared in the INTO list must match that of selected columns

The error message you're referring to will show you the line in your proc that causes the error (even when calling it from within a proc):
Msg 16924, Level 16, State...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 3:30 pm

#1063115
RE: For XML Auto Query

Please read the link in my signature and post sample data as described.
Make sure to include your expected output together with what you've tried so far.
This will help us help...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 2:52 pm

#1063092
RE: not null column is taking empty data

toparsi (10/7/2009)
Also, my question would be , is there any way of not allowing this in the development or production environment without using check contraints on the table as they...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 12:42 pm

#1063001
RE: query optimizing

Assuming @A will always be a positive number you can change
where ((avg_cost - std_cost)*in_stock >= @A
or (avg_cost - std_cost)*in_stock <= -1* @A)
to
where (ABS((avg_cost - std_cost)*in_stock) >= @A)...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

October 7, 2009 at 12:33 pm

#1062991

Viewing 15 posts - 4,876 through 4,890 (of 5,502 total)