Topics
Started by
Posts
Last post
I want my procedure to include an optional date parameter that defaults to the current date. Why do…
10 replies
I need to parse the sample data below as shown. Please help me in writing a TSQL Function. Create …
6 replies
I have a stored procedure that passes in several parameters that can be blank or a list of selected…
8 replies
hi my query is giving me erro delete top(1000) from table a join table b on a.id = b.id and b.date …
10 replies
hi i am creating script for non clustered , i need to see of particular index on column on particul…
7 replies
hi select * from tableA with(nolock) a join tableB with(nolock) b on a.id = b.id where a.date > …
10 replies
Hello, I'm having the following error when running a query : Msg 8623, Level 16, State 1, Line 1 Th…
3 replies
hi i need to move data to another table and then remove from old one ,which i needs to delete 30 mi…
8 replies
Hai friends, i ve the table like below create table student ( class_atttend datetime, name …
3 replies
Hello everybody! I'm new to FOR XML... So here is my problem: I've got a query that returns the cor…
4 replies
There is a SP which usually takes around 3 minutes to execute. Since last few days it is taking aro…
12 replies
TableName:Customer --------------------------------------------------------------------------------…
6 replies
how to calculate 2 years back data suppose today 07/15/2013 ,2 years back ,07/15/2011. how to calcu…
7 replies
Im using this syntax to get a value but it gives me a error in visual studio: The conversion of a n…
3 replies
Hi. I try to write a stored procedure. First, if record exists, it will look at recordtime. If reco…
4 replies
Viewing 15 topics - 3,361 through 3,375 (of 10,647 total)
You must be logged in to create new topics.