Topics
Started by
Posts
Last post
Hi Guys, I Executed below Query in SQL server 2005 DECLARE @FileName varchar(255) DECLARE @ExecCmd …
4 replies
CREATE FUNCTION GetTextId (@intLookupTextId int) RETURNS int AS BEGIN SELECT @intLookupTextId = max…
4 replies
Hi to all, Imagine that i have a table with the id of an ad, and i have datein (information about t…
5 replies
--I have a table Skills which are grouped CREATE TABLE Query (and_grp INTEGER NOT NULL, skill CHAR(…
14 replies
i want to remove second left join form below query ------------------------------------------------…
13 replies
I have 2 tables with similar data in. One takes preference over the other and i would like to do so…
14 replies
Dear all, I need to create dynamic stored procedure in which, i need to select id from one table,sh…
11 replies
I have a table like that, which information about user's transaction made by them. Name cit…
7 replies
Here is the scenario. Have to bcp data from a flat file to a sql server table. Upon completion of t…
6 replies
Could anyone please advise me of any concerns surrounding coding/programming against a SQL2005 data…
3 replies
create table #tmp ( id1 int, id2 int) insert into #tmp select null , null union select null , 1 un…
4 replies
Hi all, I need to display a grid of parts, order by quantity but with a twist... parts are Lefts an…
3 replies
Hello, I have a procedure which will run bulk update insert update statements. I have created some …
14 replies
Hi All, I am trying to optimize some code which basically creates a table variable, selects some va…
4 replies
Could not find an entry for table or index with partition ID 473931877515264 in database 2. This er…
2 replies
Viewing 15 topics - 1,291 through 1,305 (of 4,155 total)
You must be logged in to create new topics.