hello

i tried both and neither of them helped.

they both fixed the issue of the data conversion, but neither gives back the correct date.

alter proc ShortReporRequest_sp

@CompanyName nvarchar(20),

@RequestDate...

Hi,

thanks, but it is still not using the date. it doesnt not give an error type anymore, but the outcome of the query is not what requested.

i do understand where...

no, it was time, but i dont know what to do to get it working, so i am trying to cast here or there.

maybe i am calling the procedure wrong.

here...

ohh... i didnt declare the one of the variables... shame on me :ermm:

that being said, thanks a bunch for the help 🙂

this is the error i get

Msg 156, Level 15, State 1, Procedure general_select, Line 8

Incorrect syntax near the keyword 'select'.

Msg 137, Level 15, State 1, Procedure general_select, Line 9

Must declare...

i just google it, and it doesn't work

so basically i am asking how to fix the procedure and prevent the sql injection.

thanks!!!

Thanks so much.

I read and read and I understood. and it worked :-P:-P

Here is my code

declare @x xml

DECLARE @site_value INT;

SET @site_value = 0;

WHILE @site_value <= 1000

BEGIN

select @x = (select myxml...

The code that Bill provided yes? and it it didn't work.

I am reading the link he provided

and trying to work with that.

thanks, but I don't understand what you are trying to do.

Hi,

I have attached an excel with a sample of the data.

I don't know what you mean by converting to varchar, inside of each nod there are different values. so we...

ohhhhh :ermm: :ermm: :ermm:

no I didn't....

now I feel embarrassed :w00t:

thanks! I love learning new things 🙂

I know what the problem is now, I am supposed to get a full path and somehow I am not getting it even though they say is being sent.

thanks again...

I will try again. And read the article you sent (apparently I missed it)

thanks!!!!!

I have a table with rows that contain an xml.

I take that table and create a new table with columns containing the data of the xml.

most of the xml is...

Thanks, but that is not what i need.

I need to make a table with columns that contain the values of each one.

and the source is a table that each...