Topics
Started by
Posts
Last post
Hi Friends, Declare @t Table ( id int, EmpName nvarchar(500), status char(5), Repair int ) Ins…
17 replies
I know I am missing something I cannot figure out why I am getting this erro Msg 295, Level 16, Sta…
1 replies
Dear All, I have one sql table in the following structure (parent child up to n level) Id P…
2 replies
Hi All, May be a better way of describing what I want to do in the header, but I didn't know it. I …
12 replies
I need to generate XML results from a query and the node names need to be dynamically generated bas…
4 replies
i am parsing the textfile into table so i need to convert the data to Money Field which has 6 dig…
1 replies
I need a script as efficient as possible, to assign a unique sequence for each customer asset. My …
2 replies
I have a table similar to the one below DECLARE @Emp TABLE (EName VARCHAR(10), MthName VARCHAR(12)…
4 replies
SO a client calls in with a problem that has started happening recently and as it turns out the pro…
1 replies
Hello Friends, I am creating a stored procedure in MSSQL 2005. I have an Item table called IM_ITEM…
10 replies
Hello, I have a the following problem. I am given a particular date as an input (could be any date…
4 replies
I have a field called "OrderID" i want this field auto generate"Unique" let say "COV-YYMMDDSS" so e…
3 replies
how can i loop through a result set from a select statement in a trigger?
4 replies
Hi, Alerady I cofigured database mail with SMTP mail server. Script require for automating alert an…
1 replies
Hi, I am trying to query similar structured databases on multiple servers. Although I have many re…
1 replies
Viewing 15 topics - 2,806 through 2,820 (of 12,234 total)
You must be logged in to create new topics.