Topics
Started by
Posts
Last post
When converting a constant hex string '09FF000' to INT. It is simple as below Select Convert(Int, 0…
7 replies
hI, can anyone help me how to get the first Sunday and last Saturday of every month for a year. i n…
22 replies
I would like to write a Select Statement, which will bring additional columns from different databa…
3 replies
Hi, I have a procedure which has below query, Select a.column,count(distinct(c.column)) from table1…
9 replies
Hi All, I want to read the below xml and wherever i find p1id tag in the xml (as highlighted below)…
3 replies
hi Guys, Gals- I have the following query which works well. However, changing this to reside inside…
7 replies
Hi, I am using dynamic query in stored procedure. while i am trying to execute the SQL Query in th…
7 replies
Hello, I am trying to add multiple row data with ISnull in but I couldn't seem to make it work. My …
8 replies
Hello, I have an event process routine that creates a work table with one record in it with multipl…
5 replies
I have the following SQL that creates the output I need to capture in a variable like @SQLstr so th…
1 replies
Hi...I have a requirement, A stored proc will be scheduled to run some day in a month. It has to ge…
8 replies
I'm trying to create a user-defined function that will count the number of stores in each state and…
6 replies
Sorry if this has been covered but as you might imagine searching for this has been problematic. I …
9 replies
I have a table that has data like DDR Return PP12345 DDR Resturns PP12356 DDR Retunrs PP12367 I nee…
4 replies
Dear friends ! I have done a small project and i had some difficulties that i need your help to fix…
12 replies
Viewing 15 topics - 121 through 135 (of 12,234 total)
You must be logged in to create new topics.