Topics
Started by
Posts
Last post
Hi is there a function which determines if a varchar is a number? E.g. Select * from table where f…
11 replies
Select DISTINCT ACCT.ACCTNBR||','|| CASE PERSPERSTYP.PERSTYPCD when 'EMP' then 'EMP' else null end …
5 replies
Was wondering if someone could help me with the following query.Is it possible to connect to a defa…
7 replies
find tables /objects that are modified/updated from last N days
4 replies
Hello all, We have a job that is set to run over the weekend on one of our SQL Servers (SQL 2000 sp…
2 replies
Hi, I have some old sql code that was in the *= format that I converted to the LEFT OUTER JOIN form…
1 replies
Hi, I'm following some tutortials at the moment that ask me to create @table variables. I find tha…
3 replies
All, I have a requirement. create table #temp (name varchar(50) ) insert into #temp values ('karth…
1 replies
Hi When importing Excel 2007 data into sql via Import wizard: choose "Microsoft Office 12.0 Access…
1 replies
I need to model an unlimited number of levels in a hierarchy with jagged branches for an element we…
1 replies
Greetings to the group, I am writing an extract file from our HR system for a new implementation. T…
1 replies
Hi there, Can you guys help - I'm useless at TSQL. I have the following statment - SELECT dbo…
8 replies
I need to update a field in multiple rows with a bit of strinhg manipulation. I get an error though…
3 replies
Good Day This is my first post so please be gentle In our debt table we have a Balance field that i…
3 replies
Not entirely sure if this is possible in 2000, and I think I read somewhere you can do this in 2008…
16 replies
Viewing 15 topics - 1,021 through 1,035 (of 17,082 total)
You must be logged in to create new topics.