Topics
Started by
Posts
Last post
Assume i have 3 tables Person(personname,age) Children(childname,personname) car(carname,personname…
1 replies
Hi All, Can you please help me out on How to add '<?xml version="1.0" encoding="UTF-8"?>' …
6 replies
This is a sample of what I need to do in production. In production the field is xml. I can't have…
2 replies
I have this query that gives me Select WeekRange as WeekRange, [Open] as 'Open', [Resolved] as 'Res…
3 replies
In t-sql 2008 r2 I would like to know how to set a variable value that would be similar to declare…
4 replies
When I'm performing a de-duplication exercise on a mailing list I produce a table of potential matc…
1 replies
HI , the below query taking 5 minutes time, i want to rewrite this query ? query details : select p…
6 replies
Hi Friends, My Table looks: =========== create table billed ( InVoice_no varchar(20), model_r…
7 replies
I'm reviewing some code that will run on fairly large record sets (~1M records or more). In the co…
9 replies
what kind of locks hold inside a transaction for a select statement begin tran select 1 from table…
3 replies
Hi all, I am trying to create a query on two tables (master and detail). I am struggling with a so…
6 replies
Hi, I am having table which has no primary key. eg. tablename = tblCustomer columns firstnale,lastn…
8 replies
Hi I want store the data for history table but throwing error in this script, what is wrong my code…
2 replies
i have a requirement to get the appropriate RunID based on the Starttime. I'm not able to get resul…
1 replies
I ve the table like Billed: ------ bill references product qty …
1 replies
Viewing 15 topics - 2,551 through 2,565 (of 10,647 total)
You must be logged in to create new topics.