Topics
Started by
Posts
Last post
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
I have a 1.2 TB database in which I am updating a couple columns across 11 tables. T1 (F_name, L_Na…
8 replies
hi i need to Create process to archive the records ,anybody has any script or any ways to do it tha…
11 replies
Hi all Apologies if this is posted in the wrong section but I didnt really know where it belonged. …
5 replies
Viewing 15 topics - 3,361 through 3,375 (of 10,636 total)
You must be logged in to create new topics.